Results 1 to 3 of 3
  1. #1
    snorkyller is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    16

    How to create an option group to display the value of a field.


    One table has a field that can have multiple values. I don't know how to proceed to create an option group that show the value of this field.

    When I add this field to the form, access automatically create a combo box that opens a small window containing many check boxes when you click it.
    But I want the check boxes to be on the form and always viewable.

    I created an option group and set correctly the ControlSource property to the name of the field, but the check boxes values don't change accordingly to the fields values. All the others fields are displayed correctly on the form.

    Thank you.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    It sounds like you may be using a Lookup Field: http://www.mvps.org/access/lookupfields.htm

  3. #3
    snorkyller is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    16
    Yes, thats it. It's a lookup field based on a value list that won't change.
    This field could have multiple values and I want to display it on a form with an option group containing check boxes.

    For example, lets pretend that my field is a Colors field.

    I couldn't make it a number field as shown below, because I want to be able to select several colors. Another inconvenient is that on a report, you would see a number instead of a Color name.
    0 for Blue
    1 for White
    2 for Yellow
    3 for Green

    So I made it a lookup field based on a following value list like this one:
    "Blue"; "White"; "Yellow"; "Green"
    When you add this field into a form, Access will add a combo box. When you click on it, a small window containing check boxes appears. It works fine, but I want to use an option group instead of a combo box because I want to see the Color selection without having to click on a combo box.

    What is your advise?

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

Similar Threads

  1. Option Group - Borders are gone
    By cevatyildiz in forum Forms
    Replies: 0
    Last Post: 04-30-2010, 06:08 AM
  2. option group radio buttons
    By ManC in forum Forms
    Replies: 9
    Last Post: 03-08-2010, 03:46 AM
  3. Option Group
    By huskies in forum Forms
    Replies: 9
    Last Post: 12-02-2009, 12:06 PM
  4. option group in form
    By mawa4492 in forum Forms
    Replies: 1
    Last Post: 08-05-2009, 02:49 PM
  5. Option Group broken out
    By dcecil in forum Reports
    Replies: 3
    Last Post: 04-21-2009, 10:30 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