Primary key showing up when selecting items from list box.

[Remedial]

I created a listbox with multiple items from a table that I created. Each item that I added to the table has a primary key that is set to autonumber each new item added to the field with a new id number.

Now, why is it that when I use the list box the items are available for selection by their names, but only the primary # is shown in the field once the item has been selected.

Is there a reason for this and can it be changed so that the actual item name is shown rather than its respective primary id #?

Thank you.

 

[WayneRyan]

Remedial,

If you look at the Property Sheet, under the format TAB:

Column Widths = 0";1"

When you don't want a column to display set its width to 0.

In this example, column 1 is invisible, column 2 is 1" wide.

Wayne