DateTime field input mask

[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.

 

[Jonathan Smith]

Jim,

Are you having the users input the AM/PM portion of the time?

 

[Jim Franklin]

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.

 

[Jonathan Smith]

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