Results 1 to 3 of 3
  1. #1
    Jerry8989 is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    27

    Question How can I get Combo to display long text neatly?

    I just ran into an issue with needing to show a code and a large text value per row within a combo box. For example



    1- This is a test code 1
    2- This is a test code 2
    3- This is a test code 3

    The Text portion will be MUCH longer.
    Is there a way I can have a 400 character string show up nicely within a drop down? I know it's a dumb question but during a meeting the customer wants to be able to see all the text that goes with each code. She wants her employees to just press the 2 key and see "2- This is a test code 2" highlighted within the drop down. But when the drop down list goes away she only wants to see the value. In this case she would only see "2".

    I know this sounds really far fetched but it is what was requested.

    Any help pointing me in the right direction would be greatly appreciated.

    Thank you

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    The only realistic thing you could do is to parse the description to the tooltip text but this can be tedious. Just tell her that Access does not have this functionality. With regard to just seeing the 2 as you put it, what is 2 is this the bound column? normally the bound column is hidden but if you want to show more than 1 column then set the col widths to the size you feel comfortable with.

    David

  3. #3
    Jerry8989 is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    27
    dcrake,
    Thanks for helping with all my questions.
    That is exactly what I thought. I think she is thinking of some web app that in the past allowed her to do something like that. She was expecting to see the code and text but when she selected a row only the code would appear in the drop down and that the drop down would resize to the size of the 1 or 2 digit code.

    I will have to come up with some other way to allow the user to tab and put in numbers and see what the number codes actually stand for.

    Thanks again for all your help it is really appreciated.

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

Similar Threads

  1. Combo box to text box
    By kc21supra in forum Access
    Replies: 4
    Last Post: 08-21-2009, 01:08 PM
  2. Combo Box Display
    By ssaucedo in forum Reports
    Replies: 17
    Last Post: 08-10-2009, 05:52 PM
  3. Text too long, error message
    By taylormotm in forum Access
    Replies: 13
    Last Post: 06-18-2009, 07:24 PM
  4. Replies: 0
    Last Post: 04-13-2009, 04:02 AM
  5. Replies: 1
    Last Post: 03-02-2006, 06:17 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