Want only selection, not contents of drop-down 1

[erleichda]

When I created a report, I am getting the entire contents of my drop-down boxes in each record, with the selected field highlighted. How can I just get the text of the selected field without the rest of the contents in the drop-down? I've tried the report with both the table and a query. Thanks!

 

[scriverb]

Where is your dropdown combobox? In the report? I don't understand the situation. Please provide more info.
Bob Scriver

 

[erleichda]

Hi Bob, the Combo box is in the table. Thanks.

 

[scriverb]

erleichda: Why don't you go to my Profile and email me the database so I may take a look. Sometimes in a situation like this it is easier than trying to explain through the thread. Bob Scriver

 

[scriverb]

erleichda: Just for the record so others can learn from this it looks like the reports were created with the wizard and the controls from the table that were of the ListBox type were recreated as ListBox type in the report. So, the report is printing all possibile options for each listbox and highlighting the selection. This create a messy looking report and takes up a lot of paper.

So, I recommend that the listbox controls in the reports be replaced with TextBox controls with the Control Source pointing to the actual data in the table thus just giving you the answers that the user has selected. Because of the width of the controls and the length of some of the possibile selections it is also recommended that the Can Grow property be set to Yes so that the fully selected answer will wrap around to a second line of print and display the entire answer.

I hope this helps with the project. Bob Scriver