We've got an Access 2003 db that throws a 'type mismatch' error on a date field, and it only does that on pc's using the French language regional settings. We can run the same db successfully on a pc with the English settings. The field throwing the error is displaying '13-juin-2011' date format instead of '13-june-2011'. How can we set the form to display the date in French format without the type mismatch error, while still allowing the English-setting pc's to work? BTW, this could affect more than a few dates in our db so a db-wide setting would be most helpful as opposed to coding conditional formatting on each date field.
Thanks in advance!