Column Widths in Lookup Table

[Inetta]

I have a lookup table that has 2 columns - one for a state code and one for the name of the state. Everything works fine with selecting from the dropdown list on the form.

My question is when you look at the dropdown list - both columns are the equal width. Since the code is small and the name of the state is longer - you see the code fine with alot of blank space - and then only see the first few letters of the state. Is there a way to have the first column narrower than the second column so that the name of the state will show up? I increased the size of the box on the form - but I don't need this long box - I just need the first column to be narrower.

Thanks for any help
Inetta

 

[bob fitz]

Adjust the "Column Widths" property of the combo box.

 

[Inetta]

I did - but it made the columns of equal widths instead of column 1 being narrow and column being wider. Can I use 2 values in the same field to show the 2 columns?

 

[RainLover]

Wrong spot.

You need Column Widths. Try 2,5
It will change to your local settings.

 

[bob fitz]

I did - but it made the columns of equal widths instead of column 1 being narrow and column being wider. Can I use 2 values in the same field to show the 2 columns?

I think you changed the "List Width" property.

 

[Inetta]

I got it to work. I was using .5 and it made both columns the same width. When I entered .2, .5 it worked. Thanks so much!!!!!!

 

[RainLover]

The little things can at times can be hardest to solve.

Then when you find the answer you go, "How simple"

Best of luck with the project.