Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default text in date input mask (2003)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default text in date input mask (2003)

    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.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Default text in date input mask (2003)

    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.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •