suppress 12:00 time

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I use a single column for both date and time of events. I have two fields
(one for date, one for time) and the formats of the fields are set to just
show a date or a time, not both.

The user may enter a date in one field, but the time is not yet set. When
the date is entered, the time shows up as 12:00:00. I would like to suppress
this as it confuses the user. How to?

Sam
 
I use a single column for both date and time of events. I have two fields
(one for date, one for time) and the formats of the fields are set to just
show a date or a time, not both.

The user may enter a date in one field, but the time is not yet set. When
the date is entered, the time shows up as 12:00:00. I would like to suppress
this as it confuses the user. How to?

Sam
Click to expand...

Use an unbound control
Set it's control source to:

=IIf(IsNull([DateField]),Null,[TimeField])
 
Back
Top