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?
|
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. :) |