Susan Harkins
ssharkins at gmail.com
Thu Apr 9 11:27:44 CDT 2009
Rocky, sounds like a class to me, and in lieu of that, can't you create a function using an input mask property that you could just call rather than dealing with each individual control? You could use the label's caption as the text, right? Don't know how to help with the combo box problem. Susan H. > Dear List: > > 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?