Custom Date Format and Input Mask Trouble

[tbl]

I have a date field who's format property is

mm/dd/yyyy hh:nn

.... but I can't seem to get an Input Mask to work with that.
I've tried

00/00/00\ 00:00

.... and many variations of that.

Can anyone clue me in?

 

[Linq Adams via AccessMonster.com]

This appears to do the job:

99/99/0000\ 00:00;0;_

I have a date field who's format property is

mm/dd/yyyy hh:nn

... but I can't seem to get an Input Mask to work with that.
I've tried

00/00/00\ 00:00

... and many variations of that.

Can anyone clue me in?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[John W. Vinson]

I have a date field who's format property is

mm/dd/yyyy hh:nn

... but I can't seem to get an Input Mask to work with that.
I've tried

00/00/00\ 00:00

... and many variations of that.

I've rarely found input masks to be at all helpful with date/time fields.
Access is really clever at interpreting dates - if you have no input mask at
all, you can type

11:15am

and it will put in today's date; or

9/28 12:45am

and it will display as 09/28/2007 00:45.

An input mask knows NOTHING about times or dates - only digits and
punctuation; and it only restricts what keystrokes the user is allowed. It's
just a pain in the neck!

John W. Vinson [MVP]

 

[croy]

This appears to do the job:

99/99/0000\ 00:00;0;_

Thanks Ling--that seems to work.

 

[tbl]

I've rarely found input masks to be at all helpful with date/time fields.
Access is really clever at interpreting dates - if you have no input mask at
all, you can type

11:15am

and it will put in today's date; or

9/28 12:45am

and it will display as 09/28/2007 00:45.

An input mask knows NOTHING about times or dates - only digits and
punctuation; and it only restricts what keystrokes the user is allowed. It's
just a pain in the neck!

John W. Vinson [MVP]

Thanks John--good point.

I think it's the "/" and ":" that are slowing the data-entry
folks down (10-key'ers).

 

[tbl]

This appears to do the job:

99/99/0000\ 00:00;0;_

Thanks Ling--that seems to work.