Table input mask error

[ICTkirsten]

Hello,

I Have a field called appointment date and i have set the input mask as short date 00:00;0;_

the data type for the field is date/time but for some annoying reason this error message appear when i enter a date to the table... which for example is written like this 01/03/2003

so im not writing it in the wrong way

ive attached the msg below

Any help would b nice

 

[CJ_London]

cross post here

http://www.accessforums.net/forms/repost-another-forum-51400.html

 

[pbaldy]

Given the colon, do you think that input mask is appropriate for a date or a time?

 

[missinglinq]

The colon should, indeed, have been a hint. The Input Mask for a Short Date is

99/99/0000;0;_

not

00:00;0;_

BTW, the correct Input Mask could have been easily generated using the Wizard by clicking into the Input Mask Property box and then using the dropdown to select the proper one.

Linq ;0)>