I'm trying to create a tabular report with fields that use value lists (appear as drop down lists on the form). However, when I try to insert them in any kind of report, all of the possible values are listed. This takes up way too much space - I just wanted the selected option to show up. How do I "turn off" all of the drop down list values?

Just use a txtbox that displays the value from the qry.

In other words, in your report qry, you've probably got a look up table connected to the main rpt tbl using a key.

Just drag the actual name from the lookup table into the qry and use that as a control source on the report.

Have you done any reports aside from the wizards?

Steve

Thanks - In the past, I have created reports manually, but since it takes so long to arrange all the fields, I thought I'd try the wizard. I guess it automatically added the value list - I was unaware of the settings with the wizard. Thanks for the help.

One thing I do is keep a master report . . . that has certain settings . . . including turning off certain clicking options.

I also sometimes use existing reports for new ones that are similar . . . both for the reasons you note . . . in the time to set up a new report.

Steve