suppress 12:00 time

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
 
F

fredg

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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access General Date Forced To Have Date And Time 2
Outlook Macro to set Reminder on a Contact tomorro 9:00 4
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
excluding 12:00:00 AM from query results 4
Date and Time 1
How to enter start and end date/time in excel based on some specific value. 7
separating date and time 5
Workday Formula to include date 0

Top