>>Hi, I was looking for a solution to this:
>>We have a date field that if it contains a date, it means the item is closed.
>>If it is blank, it means still pending.
>>Now a new status is that it will be neither of these so a mgr wants all zeros to denote this. But it won't accept this, so what could be input to denote a 3rd status?
>
>Backcolor?
>Update:
>
>Sometimes I use a shape as a frame for things like this. (Visible -- !visible to mark the state)
Thanks for the ideas, the color prob wouldn't work as the data table needs to reflect the reality. If they can't agree on a crazy date, then I guess Sergey's idea may need implementing although this is an establish app and no one like's too much change!
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."