FILTERING A FORM WITH A DATE

[ramon]

Hello! I always have a problem when opening a form with a date filter or
condition parameter. The format that I always use is "dd/mm/yyyy" but when
the form opens it changes to "mm/dd/yyyy". My XP windows short date setting
is already in "dd/mm/yyyy" format. Could anyone please help me? Thank you.

Ramon

 

[Wayne-I-M]

Hi

Go to Control Box and check the Regional Settings for both date and times,
ensure they are set to UK (I assume thats what you need).

 

[John W. Vinson]

Hello! I always have a problem when opening a form with a date filter or
condition parameter. The format that I always use is "dd/mm/yyyy" but when
the form opens it changes to "mm/dd/yyyy". My XP windows short date setting
is already in "dd/mm/yyyy" format. Could anyone please help me? Thank you.

Ramon

Access treats any *literal* date as mm/dd/yyyy format. How are you setting the
filter? You might need to use an expression like

Me.Filter = "[datefield] = Format(" & strDate & , """\#mm\/dd\/yyyy\#""" & ")"

 

[Douglas J. Steele]

In addition to what the others have told you, see what Allen Browne has at
http://www.allenbrowne.com/ser-36.html or read my September, 2003 "Access
Answers" column in Pinnacle Publication's "Smart Access". You can download
the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html