Results 1 to 2 of 2
  1. #1
    misscupid is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    3

    Convert Option Box Value to Text

    Hi guys, I just want to know how to convert the value of option box ( 1, 2, 3, 4 ) into text.



    In my database, I want my field to contain "Permanent", "Seasonal", " Project", "Probationary" rather than 1, 2, 3, 4.

    How to get it in text ?

    I'm a beginner in access so I don't know this things. Please help me. ^_^

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    You can calculate this conversion in query or textbox whenever needed.

    Choose([field name], "Permanent", "Seasonal", " Project", "Probationary")

    Saving the converted value will require VBA code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 5
    Last Post: 04-01-2013, 11:49 AM
  2. Option Buttons convert values to text
    By TimMoffy in forum Access
    Replies: 3
    Last Post: 05-21-2012, 07:15 AM
  3. Convert text to datetime
    By kaledev in forum Queries
    Replies: 3
    Last Post: 01-28-2011, 10:21 AM
  4. Convert text to numbers
    By Mclaren in forum Programming
    Replies: 2
    Last Post: 05-02-2010, 01:36 PM
  5. Convert text to numbers
    By randolphoralph in forum Access
    Replies: 1
    Last Post: 03-21-2010, 10:33 AM

Tags for this Thread

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