Not sure where this should go

[Carl Parker]

I have a user that gets an error:
The value you entered isn't appropriate for the input mask '99/99/00;0;_'specified for this field.
How do I find out where this error is an how to remedy it?

Thank you,

 

[jfgambit]

In the table that is the record source for the form you have a Date/Time data type set for this field.

Look in the design view of the table.

 

[dcx693]

Look up "input mask" in the Access help. Input masks are meant to aid in data entry by formatting fields to appear in a number of pre-set and user-definable ways (like telephone numbers or ID numbers).

The error you are getting is common. For example, if you try to enter 3/2/02 when your input mask is set to something like 00/00/0000. The 0's signify required numeric entries, 9's are for optional numbers.

Perhaps you should alter the input mask or delete it entirely.

 

[Carl Parker]

Thanks

Input mask did the trick. ! ! ! !