Software

Office challenge: How do you draw a border around a report page in Access?

This week's Office challenge tests your knowledge of Access reports. You'll also learn the solution to last week's question about automatically opening Word documents at a specific zoom percentage.

It's easy to add a line to an Access report. Lines, strategically inserted, can help separate and highlight specific data. Lines aren't always enough though. Occasionally, you'll want a stronger statement, and drawing a border around the report page might be just what you need. How do you add a border to a report page? Last week we asked… How can you force a Word document to open at a specific zoom setting? Word opens a document using the zoom setting in use when last saved. If you want to force a document to always open at a specific zoom setting, you'll need VBA. Cuhlig was the only one to suggest the following subprocedure:
Public Sub AutoOpen()
    ActiveWindow.ActivePane.View.Zoom.Percentage = percentage
End Sub
where percentage is the exact setting value. For instance, to open a document at 200%, you'd specify the value 200. If you don't know how to add code to a Word document, do the following:

  1. With the document open, press [Alt]+F11 to open the Visual Basic Editor.
  2. From the Insert menu, choose Module.
  3. Enter the above code
  4. Return to the Word document and save it.
If you want to specify a specific zoom level for all documents, including new ones, add the subprocedure to the Normal.dot template file.

About Susan Harkins

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks

Free Newsletters, In your Inbox