Results 1 to 10 of 10
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Date input mask (Access 2003 SP2)

    When i enter the first digit of a date field into a subform i get the message "The value you entered isn't appropriate for the input mask '99/99/00' specified for this field.".
    The date is the only field to be entered in the subform.

    Can someone please help me out here.

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

    Re: Date input mask (Access 2003 SP2)

    I'd remove the input mask - I never use them for dates. If you don't want to do that (or if it doesn't help), we'd have to see the database.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Date input mask (Access 2003 SP2)

    Thanks Hans, here is the database, the form is frm Clients, the subform is the one on the far right which has just the 1 date field.

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

    Re: Date input mask (Access 2003 SP2)

    Unfortunately, I have very little time at the moment, but something strange is going on in the subform: when you click in a record, the entire text box is selected. It's as if Access tries to save the value immediately. So removing the input mask won't help either.
    I won't be able to look at this again until much later, sorry.

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Date input mask (Access 2003 SP2)

    Patt

    I have been looking around this and I have finally found the problem. It is nothing to do with the mask.

    The client Type form does not contain ClienttypesID that provides the link to the Travel Dates form.

    So it is not actually the date field it is complaining about, it just happen when you start to enter the date.
    Regards
    John



  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Date input mask (Access 2003 SP2)

    Well done, John, that is great thank you.

    I am surprised though, because if you make the text box visible it doesn't show #name.

  7. #7
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Date input mask (Access 2003 SP2)

    I agree with you that it is not clear what is going on here.

    I set that text box to visible early on, and thought it was ok, because it showed the correct values.
    Regards
    John



  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Date input mask (Access 2003 SP2)

    Again, thank you John.

    The field is there in the query behind the subform but it needs to be a variable on the subform itself, weird as.

  9. #9
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Date input mask (Access 2003 SP2)

    I am regularly asked to put masks on dates as they allow the user to enter dates using just numbers.

    But the mask I use is 00/00/0099;0;_ because I want people to enter at least 6 digits.

    It means that people need to enter leading zeros, but I find people seem happy to do that.
    Regards
    John



  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Date input mask (Access 2003 SP2)

    good point, thank you.

Posting Permissions

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