[AccessD] Empty Field Label

Thanks, Stuart. That was exactly what the client wanted to see. 

Best,

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Thursday, April 09, 2009 1:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Empty Field Label

Replace the "@" with your desired date format and create the Format string
as for a numeric field i.e  you need four formats:
"PositiveValue;NegativeValue;Zero;Null"
so something like:
mmm d yyyy ;;;"Date worked"[Red]

Cheers,
Stuart

On 9 Apr 2009 at 9:20, Rocky Smolin wrote:

> He also wants to extend this technique to text boxes that already have 
> a format. For example, the 'Date Worked' field has ddd d-mmm-yyyy for 
> a format.  If the field does not have a date he'd like the words 'Date
Worked'
> to appear in red.  But if I paste @;"Date Worked"[Red] into the format 
> property it'll override the date format when there's a date in the field.
> Any way to finesse that one?

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com