DateTime field input mask

  • Thread starter Thread starter Jim Franklin
  • Start date Start date
J

Jim Franklin

Hi,

I have a date time field, which I have formatted to show the date in
'dd/mm/yyyy hh:nn' format. I would like users to be able to key in the data
in the same format, so have used the Input Mask '00/00/0000" "00:00;0;_'

However, Access doesn't seem to like this - if there is data already in the
field which is being overwritten, the input mask doesn't seem to work at
all, and when I key new data in, I get told it doesn't match the input mask.

I know this is a simple question, but what am I doing wrong?

Thanks for any help as always,

Jim F.
 
Hi John,

No - the users will just enter the hours and minutes in 24-hour format. Does
this make a difference?

As an extra bit of info, I have noticed that when there is already data in
the field, when you click on the control, the date displayed switches to
General
Date format - i.e. "dd/mm/yy hh:nn:ss"

Cheers,
Jim F.
 
Jim,

That is the problem, the format you are using is seeking the AM/PM
designation.

Perhaps you should make Two Fields, One Date and One Time. That will
allow you to dictate the format for each element.

Jon
 
Back
Top