Results 1 to 10 of 10
  1. #1
    Join Date
    Nov 2009
    Posts
    4

    How make numbers (options 1,2,3) in table appear as text in forms (blue, green, red)?

    Hello,

    I am trying to set up a table in access that has to have the output as a number (for later conversion to other file for statistical analysis) however I want to create a form that displays a text from the dropdown menu that corresponds to the number in the table.

    For example...

    Table:
    Color- options should be 1, 2, or 3 and has to be a number (1 means red, 2 means blue, 3 means green)

    Form:
    Color- options would be listed as red, blue, green in the drop down boxes (so that the person entering does not make mistakes by having to mentally convert red to 1 and then choose 1). If the person chooses red in the form the table would actually show 1 so that if you were to later export the table it would only contain numbers.

    THANKS!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Just create a table for the RowSource of your ComboBox, Number, Color. Hide the number column but bind to it so that is what is stored.

  3. #3
    Join Date
    Nov 2009
    Posts
    4

    I think my post may have not been very clear

    Thank you for the prompt reply. Actually, I don't want the colors to appear anywhere on the table- just in the form. The table would have just the number (1, 2, 3, etc that represents a different color) but the form would have just the corresponding text such as red, blue, green from the drop down box. That way someone filing in the form would see just the color from the drop down box but when I pull up the form I would see just numbers. Thanks!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    As I said, create another table with the values you need and use it as the RowSource of the ComboBox.

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by malemozaffar View Post
    That way someone filing in the form would see just the color from the drop down box but when I pull up the form I would see just numbers. Thanks!
    I assume you meant to say when you pull up the table...

  6. #6
    Join Date
    Nov 2009
    Posts
    4

    Got it, thanks- quick ?

    So I created another colum while making my combo box, one with number and another with text and chose to have the number go into the table. How can I "hide" the number in the form? When I fill in the the form both the number and the text appear. Thanks again.

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Change the ColumnWidths property on the format tab to 0";1"

  8. #8
    Join Date
    Nov 2009
    Posts
    4
    Awesome! You da man!!!

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Great! Glad I could help.

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Are you ready to follow the link in my signature and mark this thread as Solved?

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

Similar Threads

  1. Make table query
    By Zahed in forum Queries
    Replies: 1
    Last Post: 11-06-2009, 05:44 AM
  2. Replies: 2
    Last Post: 10-27-2009, 07:09 AM
  3. Make a table query
    By Fiona in forum Access
    Replies: 4
    Last Post: 06-25-2009, 11:24 AM
  4. Extract numbers from text string strored in a field.
    By khabdullah in forum Programming
    Replies: 2
    Last Post: 12-23-2007, 06:55 PM
  5. Replies: 5
    Last Post: 02-08-2006, 08:42 PM

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