By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Access reverts to default date format

P: 1
Hi everybody

I have a field with a custom date format tied to it mm/dd/yy.
If I enter an invalid value of 13/10/05, access automatically resets the value to 10/05/13 and accepts the input as valid.
This appears to be a bug with Access.

Has anyone ever come across this issue before?

Cheers
Paul Gagnon
Nov 29 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi everybody

I have a field with a custom date format tied to it mm/dd/yy.
If I enter an invalid value of 13/10/05, access automatically resets the value to 10/05/13 and accepts the input as valid.
This appears to be a bug with Access.

Has anyone ever come across this issue before?

Cheers
Paul Gagnon
Paul

You will get a better response if this is posted in the Access forum.

http://www.thescripts.com/forum/forum142.html

However, if you impose a Format function on the date control like ...

Format([TextboxName], "mm/dd/yyyy") it should throw a fault that you can capture.

If you have any further questions on this, please post in the Access forum.
Nov 29 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.