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

Input date mask in access 2000 and 2003

P: 40
Hello,

I've been working on access 2000 for few days. I made some forms with textfields where you can type date. Those textfields had input mask set for short date 99/99/0000. Now software have changed and some computers have access 2000 and some have access 2003, where date format is 0000/00/00. Is there some way for input mask to change depending on access version? I know the date format will convert from 2000 to 2003 (I don't know if it'd work oposide direction) but this still does not solve the problem of "how to input date in textfield"

Cheers
Jul 9 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,366
Hello,

I've been working on access 2000 for few days. I made some forms with textfields where you can type date. Those textfields had input mask set for short date 99/99/0000. Now software have changed and some computers have access 2000 and some have access 2003, where date format is 0000/00/00. Is there some way for input mask to change depending on access version? I know the date format will convert from 2000 to 2003 (I don't know if it'd work oposide direction) but this still does not solve the problem of "how to input date in textfield"

Cheers
Change the format of the field from text to date, then you don't need an input mask because they have to enter a valid date.
Jul 9 '07 #2

Post your reply

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