List Box Bound Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On my report there are two fields that gets it's data from a single List Box.
Is it possible to indicate in two different Report fields which column from
the List Box I want to show.

Thanks
 
George said:
On my report there are two fields that gets it's data from a single List Box.
Is it possible to indicate in two different Report fields which column from
the List Box I want to show.
Click to expand...


Use the Column property.

=Forms!theform.listbox.Column(2)

will display the list box's third column's value.
 
Thanks - That works !!! What if I want to show both columns ?

I tried =Forms!theform.listbox.Column(2)+ Column(3)

Didn't work...

George
 
George said:
Thanks - That works !!! What if I want to show both columns ?

I tried =Forms!theform.listbox.Column(2)+ Column(3)
Click to expand...

You have to use the full object reference for each one:

=Forms!theform.listbox.Column(2) & " - " &
Forms!theform.listbox.Column(3)
 
That works as well - Thanks a lot....

Marshall Barton said:
You have to use the full object reference for each one:

=Forms!theform.listbox.Column(2) & " - " &
Forms!theform.listbox.Column(3)
Click to expand...
 
Back
Top