mm/dd/yyyy to dd/mm/yyyy

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

On Mon, 17 Jul 2006 13:00:01 -0700, Andy
wrote:

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]

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Andy" wrote in message
...
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