How do I have multiselect list box to show values in report?

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

Guest

I have a multiselect list box in a form, where I can choose items in a list.
I can't seem to have it show in either a query or a report?
Help, please!
 
Vanderzee said:
I have a multiselect list box in a form, where I can choose items in
a list. I can't seem to have it show in either a query or a report?
Help, please!
Click to expand...

Have WHAT show? If you are trying to use a multi-select list box as a bound
control to save data into a table that will not work. As it is a violation of
proper database rules to store multiple values in a single field a multi-select
ListBox always has a value of Null.

The only legitimate use for these is in a code routine where you need to do
something with the selected values. In VBA code is also the only place where
you can retrieve the selected values from a multi-select ListBox by looping
through the ItemsSelected collection of the control.
 
Back
Top