I am trying to use VB to force my date format to be DD/MM/YYYY in Access. Some computers we use for data entry will have the session.LCID set to US time (and thus MM/DD/YYYY) and some set to UK time (DD/MM/YYYY). For the purposes of this question, let's just say that we can't change the setting manually in the Control Panel.
I want my field to stay in date/time format unless you have a really easy work-around for using a text field. The main reason is that I need to be able to make date calculations in this database.
I tried the following code into the VB code for my form, but it didn't work:
Session.lcid = 2057
Any better ideas of how to achieve this?