Date format in text box

  • Thread starter Thread starter Del
  • Start date Start date
D

Del

I'm using Access 2000. How can I get the diagonal lines that seperate the
MM/DD/YYYY to appear in a text box before the user enters the date?
 
You need to setup the control's 'Input Mask' property

Open the form in design mode
Right-Click on the control
select properties
goto the data tab
goto the input mask property
click on the ... button
either select an existing mask or create a new one to suit your needs.

another solution, instead of using keyboard input and having issues with the
format in which dates are entered is to use a date picker / Calendar. If
this interests you take a look at

http://allenbrowne.com/ser-51.html

or

http://www.lebans.com/monthcalendar.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Select query with date range format issue 2
Date Formatting 1
importing ambiguous dates 4
Set Default Date to European Format without changing Regional settingof the PC 6
Strange Julian Date Phenomenon 9
Format Date Display in Access ADP 1
Forcing a date entry format of dd/mm/yyyy 1
Date format error 10

Back
Top