Oct 16 2006, 01:09 PM
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?
Oct 16 2006, 07:07 PM
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?
Oct 17 2006, 08:49 PM
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.
Oct 18 2006, 04:13 PM
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here