After we upgraded to Access XP, the users began getting errors anytime they updated a date field with existing data in it. It would say that the information wasn't valid for the field.
This affected both database that I converted to XP and ones I left as 2000--but all used in XP.
What was happening: Access 2002 automatically displayed a four digit date, overriding the input mask. But when the user tried to make a change, the input mask immediately rejected the date because of the extra two digits. All the input masks needed to be changed to four digits.
Linda Adams
Linda Adams/Emory Hackman Official Web site Official web site for actor David Hedison:
This affected both database that I converted to XP and ones I left as 2000--but all used in XP.
What was happening: Access 2002 automatically displayed a four digit date, overriding the input mask. But when the user tried to make a change, the input mask immediately rejected the date because of the extra two digits. All the input masks needed to be changed to four digits.
Linda Adams
Linda Adams/Emory Hackman Official Web site Official web site for actor David Hedison: