How to activate the "Gridlines" group in the Design tab (for reports)?

GraveyardPoets
GraveyardPoets used Ask the Experts™
on
I'm sure the answer is nose-on-my-face obvious, but how does one activate the Gridlines command group in the Design tab (when viewing reports in Design view)? All four buttons (Gridlines, Width, Style, and Color) are always grayed-out, and I can't figure out which hidden switch or secret incantation needs to be invoked in order to activate them. Access "Help" is of no help.

Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Right click on the report in desing view. Click grid in the dialog box.

Author

Commented:
sb9, that turns the actual grid on or off, but it doesn't activate the "Gridlines" command group in the ribbon.

Commented:
I thought that was what you were looking for. Sorry not much help with A2007, never used it.

I am sure another expert will be able to assist
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Commented:
It may help to increase the number of points you are offering as some expert set their filter to exclude low scoring question. Since you are only giving 50 points a lot of expert will not see you question. Try 300-400
MIS Liason
Most Valuable Expert 2012
Commented:
Th Gridline option will only become available after you select a control that has a "Layout" applied...

For example:
In an Access 2007 format DB, if you create a simple tabular report using the wizard there will be a "Layout" applied.
You can go into Design View (or Layout View) and select any control in the layout and the Grilines option will become available.

If you are *sure* that no layout exists (This report was imported from Access 2003,or the layout was removed manually) You can select all the controls you want in the Layout and click: Arrange-->Control Layout-->
...then select eithe Tabular or Stacked.
Then if you click on any control in the Layout, the Gridline options will be available

;-)

JeffCoachman

Author

Commented:
Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial