Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

pull down list from table with 4 colums looks weird when choice made

I have an access 2003 database.  For one field, the user chooses an available case number from a combo box for a client.  
The drop down has 4 columns based on the case table so that they case number has some meaning (case ID #, sequential case number for particular client, reason for referral).
I think I have set this up poorly and am looking for advice.  Once the case is chosen, it writes that case number to the table for that contact (appointment) but I am left on the screen with a very wide field with a short number in it.  This looks odd and unprofessional.
Some ideas I have floating in my head are to write the values of all the fields to the appointment, but this seems like poor database design since this would duplicate info into 2 tables.  Another idea I had was to make the size of the field change through code when the user is not choosing a value, but I am not sure how to do this and it sounds like it would look weird to the user.

Thanks, Experts!
0
Nero83
Asked:
Nero83
  • 2
1 Solution
 
nap0leonCommented:
It's been forever ago sine I've used MSAccess combo-boxes... but you used to be able to have the input field be a fixed width but the actual drop-down for the input be much wider (e.g., the form field is only 1" wide, but when you click the arrow to get the select-box choices, the drop-down could be 3 or 4 inches wide).

Since it has been so long, I cannot say whether you can still do this or what the name of the property is that you edit to make this happen.
0
 
Nero83Author Commented:
This sounds pretty ideal, and like something I should be able to do, but I don't know how.
0
 
Dale FyeCommented:
Combo boxes have a Width property, as well as a ListWidth property.  Set the Width property wide enough to display whichever field you want to display after the item is selected.  Then set the ListWidth property to a width that will display all of the fields when it is dropped down.
0
 
Nero83Author Commented:
That'll do the trick!  Thanks fyed!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now