Results 1 to 7 of 7
  1. #1
    aodonnell
    Guest

    Input Mask - short date? (Access 97 or 2000)

    I am trying to set an input mask for a 4-digit date. I only want users to type in the month and day, not the year (mm/dd). Is there any way to do this? Probably basic, but I'm stumped. Thanks.

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Input Mask - short date? (Access 97 or 2000)

    Try setting the form (or table) field's format property to "mm/dd/yy". If the user types in "7/27" and <Enter> or <Tab>, "07/27/01" will be displayed (the current year will be assumed). No input mask required. Of course, this does assume you WANT the current year.

  3. #3
    aodonnell
    Guest

    Re: Input Mask - short date? (Access 97 or 2000)

    No, actually the problem is I want no year.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Input Mask - short date? (Access 97 or 2000)

    go to table design and set the fields format to mm/dd

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

    Re: Input Mask - short date? (Access 97 or 2000)

    You can't save a date without a year, you can only format it to appear that way. However, it isn't something I recommend because you have no visual check to make sure the user hasn't done something creative with his system date that will make nonsense of your data.
    Charlotte

  6. #6
    aodonnell
    Guest

    Re: Input Mask - short date? (Access 97 or 2000)

    Thank you Jerry. I think that will work. I knew the solution couldn't be that hard. The field is for birthdays and I don't want to display years or even have users enter a year.

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

    Re: Input Mask - short date? (Access 97 or 2000)

    In that case, why bother storing it as a date at all? You could easily store it as text and create an input mask for that.
    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
  •