mm/dd/yyyy to dd/mm/yyyy

[Guest]

Hi there,
I have a form that when using a pop-up calendar, once the date is selected,
automatically converts it to mm/dd/yyyy. My regional settings are dd/mm/yyyy
and need the form to show the date like this.
It also drops a leading zero on the month value.

Thanks

 

[John Vinson]

Hi there,
I have a form that when using a pop-up calendar, once the date is selected,
automatically converts it to mm/dd/yyyy. My regional settings are dd/mm/yyyy
and need the form to show the date like this.
It also drops a leading zero on the month value.

Thanks

Set the Format() property of the textbox in which the date is
displayed to dd/mm/yyyy.

John W. Vinson[MVP]

 

[Allen Browne]

It might depend on how that form passes the date value back as to how Access
interprets it.

This one works correctly in a d/m/y country:
Popup calendar
at:
http://allenbrowne.com/ser-51.html

You might also need to know how to address the 3 cases where Access tends to
get our date formats wrong:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html