[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 551
  • 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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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