Link to home
Start Free TrialLog in
Avatar of mjburgard
mjburgardFlag for United States of America

asked on

Access drop down format question

I have a drop down box that only shows our first bit of infomation.  See the image:
User generated image
As you can see, the line we select shows more information than the drop down does.  I would like the drop down to show all of that information as well.
If this does not display, I will reformat it, so let me know.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The information you are selecting there looks like it should really be stored in separate "Fields"
As evidenced by the comma separating the "bits of information"

Please know that once you need to display more than about 3 fields, you would typically display/select just the the name and display the "other bits of information" directly on the form (so that they are easier to read.)
...else your combo total width will be unnecessarily long.

1. It is not clear from your post what you are ultimately doing with these selections.
2. Nor is it clear how these "bits of information" are actually stored in the table...
If you provide the answer to both of the above questions, then we can suggest more targeted solutions.

Until then, examine this very basic sample

JeffCoachman
Database109.mdb
Avatar of mjburgard

ASKER

Exactly what I needed. Thank you.