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.
"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.