[AccessD] Empty Field Label

Dear List:

I think it was Gustav that turned me on to putting some text into an empty
bound text box using: @;"Select Matter "[Red] which displays the words
'Select Matter' in red if the field bound to the text box is null.  Works
great in a continuous form.

My client now wants to extend this to combo boxes.  I tried it but it didn't
work.  Probably because the first column of the combo box is zero width -
containing the PK.  Is there a way to use @;"Select Matter "[Red] so that it
will display in the second column of the combo box?

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?

 

MTIA,

 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/>