Results 1 to 5 of 5
  1. #1
    rlbroerman
    Guest

    limit to text box (2003)

    I want to be able to put only the numerals 1,2,3,4,& 5 into a text box. How do I do this?
    Thanks.
    Rick Broerman

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

    Re: limit to text box (2003)

    There are a few options.

    My first choice would be to change the text box into a combobox that only offered 1,2,3,4 ,5, and set the Limit to List" property to Yes.

    Alternatively set up a validation rule, either for the control on the form, or the field in the underlying table. when you create a validation rule, you should also specify the validation text, which becomes the message wehn the rule is violated.
    Regards
    John



  3. #3
    rlbroerman
    Guest

    Re: limit to text box (2003)

    The last part of your post did not come, thru can you send it again, please.

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

    Re: limit to text box (2003)

    Everything I posted last time is still visible in my previous post here in the Lounge.

    The image is an attachment and is not included with email version of the reply. To see the attachments you need to view the post in the Lounge.
    Regards
    John



  5. #5
    rlbroerman
    Guest

    Re: limit to text box (2003)

    Thanks, it works great.

Posting Permissions

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