reports and list box from table query

[bml337 via AccessMonster.com]

i created a report based on 3 tables. One of the tables is tied into a list
box/query to get the correct options. However, when i create the report...
the list box is also created on the report. With the correct selection
highlighted in black. This also shows the other possible options with a
scroll bar.

I just want the selection to show up on the report.... would it make a
diffrence if it was a value list? the options hardly ever change, but there
are around 60 options.

bl

 

[Guest]

You should not use a listbox data-type in a table. I saw this done once and
was at a loss to determine why someone would do that. I didn't even know it
could BE done. Whatever data-type is defined in your tables is what will
appear on the report.