Results 1 to 4 of 4
  1. #1
    Deisun is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2011
    Posts
    14

    Textbox to display text for corresponding value in table

    I have a table with a number field: CustomerRating

    "1" = great customer
    "2" = average customer


    "3" = bad customer

    So in the table field, all I see is a number for each client.

    On my form, how do I show text to the corresponding value?
    I don't want a list or combobox, just a textbox.

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    I don't want a list or combobox, just a textbox.
    Out of curiosity, why do you not want to use a list or combo box?


    Not using a list or combo box may prevent you from editing a record, and depending on your relationships, it may prevent you from adding a new record.

    Are the descriptions corresponding to the numbers stored in a separate but related table?

    To display the value associated with the number, you can use a query for your form. The query would include the main table (customer table I assume) as well as the table that holds the rating description. Alternatively, you could add a new control to your form and use the DLookup() function to pull the value from the table dependent on the numerical value of the rating for the particular customer.

  3. #3
    Deisun is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2011
    Posts
    14
    The reason is I'm creating a Search list and it's only 1 line for every result found and I really just want that 1 line to not be editable and so having the dropdown box of a combo box or list is cluttering up the design.

  4. #4
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    If you don't want it to be editable then you can use one of the methods I suggested earlier.

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

Similar Threads

  1. Replies: 5
    Last Post: 08-11-2011, 05:38 PM
  2. Replies: 5
    Last Post: 06-28-2011, 06:40 PM
  3. Display PASS or FAIL using Unbound textbox
    By Shambler2 in forum Reports
    Replies: 7
    Last Post: 06-02-2011, 11:19 AM
  4. How do you make a text box display a value from a table?
    By italianfinancier in forum Reports
    Replies: 3
    Last Post: 06-01-2011, 12:15 PM
  5. Replies: 2
    Last Post: 11-16-2010, 10:55 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