[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?