List Box

[Anthony W]

I have a list box named TYPE_LPG. Underneath i have a
text box with the control source of =[Type_lpg].column(1)
which shows me the contents of the second column of my
list box.

What i want is to be able to show the 2nd and 3rd columns
of my list box in my text box.

Does anybody now how this is done?

Thanks in Advance

Anthony Webb

 

[chas]

Hi Ant,

errrmmmm.......slap my wrist ;-). I left in an extra =
when I copy/pasted your code. Try this instead:

=[Type_lpg].column(1) & " - " & [Type_lpg].column(2)

btw, you can replace/omit the " - " or use a different
seperator or just leave a space.

hth

chas

-----Original Message-----
Thanks for replying Chas, havee tried it but it is telling
me "You may have entered a commar without a preceeding
value or identifier".

Any ideas?

Ant

-----Original Message-----
Hi Anthony,

Try changing the ControlSource of the TextBox to read:

=[Type_lpg].column(1) & " - " & =[Type_lpg].column(2)

hth

chas