Default text in date input mask (2003)

Topic

New Reply

We want to only display mm/yy but if you type in say 10/05 (for october 05) it will display as 05/06 (taking the 10 as the 10th of May).

I thought I should be able to create an imput mask 01/00/00 which would allow the input of 10/05 but put 01 in automatically. But it does not want to work for me. Can anyone suggest what I can do (it is proving difficult to persuade people to enter 01/10/05!!!).
Regards
Roberta

Reply | Quote

Replies

Windows does not provide for entering dates this way. Alternatives:

– Provide a combo box with two columns: the first, hidden column contains a list of dates 01/01/05, 01/02/05, 01/03/05 etc. (assuming dd/mm/yy format), the second column contains January 2005, February 2005 etc. The user sees only the second column, but the value from the first column is entered in the table.

– Provide separate text boxes or combo boxes for month and year.

Reply | Quote

You can also use an unbound textbox to capture the mm/dd format and then use code to populate a date field from that, but as you discovered, entering only two segments of a date leaves Windows dealing with ambiguity, which is not its strong suit.

Reply | Quote