List Box

[Desperate access user]

Hi Everybody! I need an answer, I have a problem with showing a field when I
create List Box, Example: I start wizard for creating list box, then i choose
which field should be showing ( Name, Surname and ID) but the surname field
does not show, who can help me resolving this problem.

Thank you

(e-mail address removed)

 

[Wayne-I-M]

Hi

Say you have a table called tblClients
In the table you have:
ClientID
1stName
Surname

Your list box will show these fields (if you want)
BUT
It is the first field that the list box will display that has a column width
more than 0

So to show these fields in the list box you will have

Column source
SELECT [lclients].[ClientID], [clients].[1stName], [clients].[Surname] FROM
[clients] ORDER BY [Surname];

Column count
3

Column widths
0cm;2.54cm;2.54cm
In this case the box will display the 1st name

Column widths
2.54cm;2.54cm;2.54cm
In this case the box will display the ClientID

Column widths
0cm;0cm;2.54cm
In this case the box will display the Surname

BUT the "bound" column will be stored in the table or used in a calculation
or other function regardless of what is "displayed". This is very useful if
you want to use the list box to filter other "stuff".
So if you have 10 John Smiths in your table - even though one of the John
Smiths is show in the list box the filter will still know which specific John
Smith you are useing.

Good luck