DateTime field input mask

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.

Jim,

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

"Jim Franklin" wrote in
:

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.

"Jonathan Smith" wrote in message
. 6...
Jim,

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

"Jim Franklin" wrote in
:

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.

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


"Jim Franklin" wrote in
:

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" wrote in message
. 6...
Jim,

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

"Jim Franklin" wrote in
:

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.