Format Date "dd/mm/yyyy"

C

Carl_and_Earl

I have a bound text box and I want to display a date, but formated like this
"dd/mm/yyyy".
I tryed to input a mask like 99/99/0000;0;_, but when I insert in the text
box let's say 31/12/2008, on lost focus changes to 12/31/2008.

I also tryed to set VBA on lost focus.

Private Sub Data_LostFocus()
Dim MyResult, MyDate
MyDate = #12/31/2008#
MyResult = Format(MyDate, "dd/mm/yyyy")

Doesn't change a thing.
How can I change the format to be able to insert "dd/mm/yyyy"
Thanks.
 

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

Top