Date Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables in the database, both with date fields. I have set up an
input mask of day/month/year in both. In one of the tables I am able to
enter this way but the other table is changing to month/day/year even if I
enter it as day/month/year. That was the first problem. Now after entering
dates in the second table that is not working correctly, I can not add dates
at all. It just stays blank. Is this a bug or problem? It seems funny when
they are set up exactly the same way and time that one table is working and
the other is not. Please help. Thanks.
 
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
 
Back
Top