Date field is being reversed

J

Jenn Civello

In one table I am entering the date as day/month/year and in another table I
am entering it the same way but it is coming month/day/year and I can not
change it. I am getting the following error message "The value you have
entered isn't valid for this field. For Example, you may have entered text
in a numeric field or a number that is larger than the field size permits" I
have the input mask set as a date field.
 
A

Allen Browne

Remove the input mask. It does nothing but clutter up the entry.

Also remove anything in the Format property so you don't get inconsistent
displays.

For an explanation of how to work with dates in Access in a d/m/y country,
see:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html
 
J

Jenn Civello

Thank you that helped. Is there a way to have a calendar pop up when you are
typing the date so you can just select the date that you want?
 
C

Chris Mills

In addition (I hope Allen agrees) to his section
"Unfortunately, Microsoft tried to be too smart at helping Access accept
dates..."

I believe it is necessary for (European dateys) to test one's product BEFORE
the 13th of a month (but obviously not on 1/1, 2/2, etc), otherwise the
product might check-out fine on all but 12 days of a month.

No you don't have to wait a month to start testing ;-)

Chris
(European datey)
(Where testing takes 3 times as long!)
 
A

Allen Browne

Sure. There are heaps of free calendars around, such as this one:
http://allenbrowne.com/ser-51.html
The article also has a link to a more comprehensive wrapper by Stephen
Lebans.

There is a built-in ActiveX calendar control in Access, but I don't
recommend it (versioning/reference problems for starters.)
 
A

Allen Browne

You can download the calendar form from the link in the previous post.

You can use it in a form (not a table.) The form is designed to be the user
interface in Access.
 
Top