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 template file.