Results 1 to 4 of 4
  1. #1
    Richard_Marx is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2013
    Posts
    36

    Set Allowed Values for A Textbox


    I have a textbox on my form that is bound to a table field. I want to only allow the user (and maybe I should alter it from a textbox to a drop down list, thoughts?) to select Verified or Not Verified as entries for this field. How do I set up allowed values for a textbox?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    You could put the allowed values in a table. Use that table as the rowsource of a combobox on your form.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    If there are only two possible answers to the question, the best data type for the column in your table would be a Yes/No field. There are a few options for control types that work well with Booleans. You could certainly use a combobox. Another option could be a checkbox. It may be more intuitive to use radio buttons and create an Option Group using the Wizard.

  4. #4
    Richard_Marx is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2013
    Posts
    36
    Quote Originally Posted by orange View Post
    You could put the allowed values in a table. Use that table as the rowsource of a combobox on your form.
    Set it as the rowsource, that is the step I was missing. Thank you @organge

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 07-25-2014, 03:18 PM
  2. Multiple Values in textbox
    By frksdf in forum Forms
    Replies: 10
    Last Post: 07-14-2014, 11:41 AM
  3. how to set textbox to values from query
    By kassem in forum Programming
    Replies: 1
    Last Post: 06-23-2014, 02:53 PM
  4. Replies: 5
    Last Post: 06-11-2014, 05:10 PM
  5. Not sure why textbox not working for some values
    By jtkjames in forum Programming
    Replies: 1
    Last Post: 07-21-2010, 04:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums