Results 1 to 2 of 2
  1. #1
    Cyber27uk is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2013
    Posts
    1

    Post Option Buttons

    Access 2007



    I Have a customers table and within that table a field called 'hearaboutus' (data type - Number). From this table I have a customers form and on this form an option group with 5 option buttons:

    Newspaper
    Yellow Pages
    Yell.com
    Word Of mouth
    Thomson Local

    The control source for the option group is 'hearaboutus'

    Is it possible to some how display the information contained in 'hearaboutus', may be in a graph?

    Thanks for your time

    Mark

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    So the option group is:
    1 - Newspaper
    2 - Yellow Pages
    3 - Yell.com
    4 - Word Of mouth
    5 - Thomson Local

    I would look into the Switch() function. It can be used in a query or as the control source for a text box.

    In a query, a column would look like
    Code:
    About Us: Switch([HearAboutUs]=1,"Newspaper",[HearAboutUs]=2,"Yellow Pages",[HearAboutUs]=3,"Yell.com",[HearAboutUs]=4,"Word Of mouth",[HearAboutUs]=5,"Thomson Local")
    As a text box control source:
    Code:
    = Switch([HearAboutUs]=1,"Newspaper",[HearAboutUs]=2,"Yellow Pages",[HearAboutUs]=3,"Yell.com",[HearAboutUs]=4,"Word Of mouth",[HearAboutUs]=5,"Thomson Local")

    This only one method of converting a number to text value.

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

Similar Threads

  1. Option buttons
    By Ecal in forum Programming
    Replies: 2
    Last Post: 11-11-2012, 09:04 AM
  2. Use of option group buttons
    By sireesha in forum Forms
    Replies: 1
    Last Post: 10-25-2012, 01:20 PM
  3. How too use check boxes and option buttons
    By newtoAccess in forum Forms
    Replies: 0
    Last Post: 12-03-2010, 04:41 PM
  4. Option buttons
    By chazcoral2 in forum Forms
    Replies: 11
    Last Post: 09-13-2010, 07:53 AM
  5. option group radio buttons
    By ManC in forum Forms
    Replies: 9
    Last Post: 03-08-2010, 03:46 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