FILTERING A FORM WITH A DATE


R

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
 
Ad

Advertisements

W

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).
 
J

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\#""" & ")"
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top