Hello all,

I am writing some vb codes via Microsoft access 2010 to perform some sql queries to Access tables.

Something strange is happening.

Below is my code

Dim tDate

tDate = #28 June 2013#

once I hit enter, tDate will change to tDate =#06/28/2013#

Where can I make settings not to change the format?

Thanks a lot!