combo box showing in report

[mmmk]

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]

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]

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]

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]

This is a report generated from a form. I can not edit the report text boxes.

 

[vbaInet]

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]

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]

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.