I need to insert a date into a date field in access using VBA code, but when I do, it converts to US Format – i.e. 4th October turns into 10th April. All settings on my PC is in Aus locale. I have read posts about other users having this problem but I cannot find a specific article on how to get around this – Can you help me ??
