• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 573
  • Last Modified:

best input mask for birthday

Please give me the best input mask for birthday in MS Access.
Now I use 90/90/0000
But month is from 1 -12, day 1 - 31 and year 1900 - 2200.  So how can I improve the mask?
0
Jinghui Li
Asked:
Jinghui Li
1 Solution
 
shanesuebsahakarnCommented:
Set the textbox's Format property to Short Date - that will then not allow invalid dates to be entered.
0
 
grayderekCommented:
use 09/09/9000 which appears as 09/09/9000;0;_
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now