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;_
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: