Software

Ask something
Discussion Locked

Date Input Mask

0 helpful
3 replies

by djpinson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In Access 97 I have created a form to list conferences. I would like the user to enter the date range as follows. I am having trouble formatting the input mask to put in my date field. The date range would be:

February 21-23, 2001Can someone help me with this?

3 replies

by churdoo

How about a drop-down box for the month and year, and either drop-downs for the dates too, or fill-in with a 99-99 mask. You can put code behind the form to concatenate the fields to the string you want. How does your methology handle conferences that start in one month and end in another though, like February 26-March 1, 2001?

This discussion is closed to new replies.