>>>Hi Bruce.
>>>
>>>What about using the DynamicFore and BackColor properties to turn colors to White on White if EMPTY(date)? You could always re-enable the normal colors on GotFocus.
>>
>>That seemed like a great idea, until I went to implement it. I also have DynamicBack & Fore colors for highlighting, and the column change has a conflict - one dynamic change "overwrites" the other (depending on which way they're ordered)...
>
>Bruce,
>
>How about DynamicCurrentControl? Maybe you could have a control not bound to anything.
Yes, I thought of that...I was hoping for some quick Format idea, maybe :)
Probably easiest, though it'll cause some re-work in a few places, is to just put the dates into grid cursor using IIF(empty(date),empty string,DTOC(date)), since it doesn't need to be editable here...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.