Hide default date

Hide default date

  
Start Date Time 01-01-1900 00:00:00
End Date Time 01-01-1900 00:00:00

I have an example where a record is saved with default value for date.  However, where the date is the default value, I want to hide it from the user.  I tried enclosing it in an IF with the condition <date_colum> = "'#01-01-1900 00:00:00#" but this doesn't appear to work.  Any ideas?

Hi Colin,

That became a problem with my project too, I used a variable and assign it to the textbox as a work-around.
Don't forget to use that variable in displaying or saving the date.

Regards,
Mark Chua

Have you tried defining the "default value" property in the textbox widget to #1900-01-01 00:00:00# if you're using a DateTime, or just #1900-01-01# for a Date?

Hi Colin,

" I tried enclosing it in an IF with the condition <date_colum> = "'#01-01-1900 00:00:00#" but this doesn't appear to work.  Any ideas?"
Change it to "<date_column> = nulldate()" and try again.

Cheers,
Hermínio Mira
Hermínio,

Perfect....  Works a treat.  Thanks.

Colin