previously wrote:
*From:* is********@yahoo.com
*Date:* 9 Dec 2004 00:52:41 -0800
Hello,
Is there a way in which users can be prevented from making changes to
regional settings in Win XP Professional edition so that the
interpretation of dates by an Access application remains consistent for
all users?
Thanks
Isaac
This should not be necessary. (And in any case, why would users be
changing their regional settings?)
If the date is manually entered correctly according the user's local
settings then it will be displayed correctly on any other user's machine.
Always format date entry fields on forms with month names (medium or long
date) so that visual confirmation of the entry is simple.
The issue with dates arises in VBA and SQL where it is necessary to force
dates into an unambiguous format for code-based data entry (for example
in SQL queries), otherwise they will be assumed to be in mm-dd-yy format,
if this produces a valid date.
You can do this by always formatting the date as yyyy-mm-dd for entry as
this will never be misinterpreted.
Peter Russell