How to fix the display columns in a list box...

[CFP - Jason]

how to i fix it so it shows the second column which is tha actual name not the ID number.

here is what it looks like i dunno how to explain this correctly.
thanks
jason

 

[Vassago]

I'm afraid I don't completely understand. Maybe if you post a sample of the database, I'll be able to understand a little better.

 

[RichMorrison]

Jason,

Looks like you have 2 columns in the list box. One column contains "97" and the other contains some name that goes with 97.

Right ?

The column with 97 is the "bound" column and that's what shows when you pick something from the list. You can't change that behaviour.

What you can do is make a textbox next to the list. Then make an AfterUpdate event sub for the list. In the sub, you assign the column of the list box with the name to the textbox.

Something like:
Me ![SomeTextbox] = Me![SomeList].Column(1)
(That assumes the name is the **second** column. Column number start with zero)

Then Repaint the form.

RichM

 

[ghudson]

Assuming that you have two columns and the first one is bound...

Set the List Boxes format properties as follows:

Column Count = 2
Column Widths = 0";1"
Width = 1"

You can adjust the 1" widths to what ever works for you but the 0" width for the first column is how you hide a column in a combo box or list box.

HTH