Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Input Mask Creation (Access 2002)

    Here's the issue. If someone's entering data for people's titles (Mr. Mrs. Ms. Miss) how could they create an input mask that would work for these variety of titles. I tried many combinations but with the period involved and a variable number of letters it seems almost impossible. Thanks for any info.

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

    Re: Input Mask Creation (Access 2002)

    Instead of using a text box with an inpit mask, I would use a combo box.
    Create a table with one text field named Title and populate it with the possible titles. Use this as row source for the combo box. If you set Limit to List to Yes, the user is forced to select a title from the list, otherwise, it is possible to type a title that is not in the list.

Posting Permissions

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