List Box

  • Thread starter Thread starter Anthony W
  • Start date Start date
A

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
 
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
Click to expand...
Click to expand...
 
Back
Top