Enter 01/03/2004 in textbox changes to 03/01/2004 and vice-versa

Laftrip

Registered User.
Local time
Today, 04:25
Joined
Apr 23, 2004
Messages
23
I have a problem which I have tried to resolve in many ways with no success.

To troubleshoot my problem with as little possibility of error as possible, I have created a form with nothing but a textbox. The textbox is unbound.

I have set the format (Me.txtDate.format = "mm/dd/yyyy") and in my computer's regional settings, in the Date tab, I also have MM/dd/yyyy.

Here's the deal, if I type 01/03/2004, then move the focus out of the textbox, the display changes to 03/01/2004.

If I type 03/01/2004, of course now it changes to 01/03/2004.

If I enter a day that is higher than 12, then no problem. I don't want to resort to 3 textboxes, one for the day, month and year... but I'm beginning to lose patience on this issue.

I know I have read a similar post about a month ago on this forum, but I have searched and can't seem to find that post again.

If this has been resolved, please indicate where I can find a solution, or if there is somebody out there able to answer my question, please do, I will be a happy boy once I can move on.

I should also mention I have set an input mask of: 00/00/0000;0;_
 
Last edited:
Ok, I've tried using the database on other computers and noticed that on the computers with WindowsNT this problem doesn't happen.

I have Windows 2000 Professionnal on my machine.

Does anybody know of any issues, or extra settings that I should look at?
 
Have you set the regional settings General Tab to 'English(United Kingdom)' ?
 
___ said:
Have you set the regional settings General Tab to 'English(United Kingdom)' ?

Well, I'm in Canada and we are using the United States format because that is where the company headquarters is located.

I've found a way around my problem, I've removed the format property (the bug no longer happens) and kept the input mask and will do the insert using the string in vba.
 

Users who are viewing this thread

Back
Top Bottom