View Full Version : combo box showing in report


mmmk
06-30-2010, 12:37 PM
I can't figure out how to format my report so the combo box options are not displayed. I attached an image to show what I'm talking about. Any ideas?

vbaInet
06-30-2010, 12:47 PM
When you say options what do you mean? It shouldn't show the first column which are numbers?

Can you show a screen shot of the whole report and circle in red which bit you don't want to be visible. Or elaborate.

mmmk
06-30-2010, 12:55 PM
The 5th column on my attached screen shot shows the months with the selected month highlighted. I want just the selected month to be visible (July), without listing the other months included in my drop down list. I didn't have this problem until I added combo boxes to my form.
Thanks

vbaInet
06-30-2010, 01:00 PM
So this isn't a report?

Does the "combo box" collapse and hides the other values when you move to another control (like to another text box)?

mmmk
06-30-2010, 01:04 PM
This is a report generated from a form. I can not edit the report text boxes.

vbaInet
06-30-2010, 01:05 PM
If it's a report that's showing a full list then it's a list box. Right-click on it and CONVERT TO Combo box.

If you're still having problems, post a stripped down version of your db with the report and I'll have a look.

mmmk
06-30-2010, 01:24 PM
Thankyou!, that solved the problem. I was confused because they are all combo boxes in my form, I thought they would stay like that on the report.

vbaInet
06-30-2010, 01:32 PM
You're welcome.

Sometimes Acces tends to decide what type of control is best for your data especially if you're converting from a form to a report. It probably did it based on the fact that there are only 12 items in the list. Bad choice for a report though. :)