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 Subwhere 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:
With the document open, press [Alt]+F11 to open the Visual Basic Editor.
From the Insert menu, choose Module.
Enter the above code
Return to the Word document and save it.
Related Topics:Enterprise Software Developer Open Source Software Mobility Cloud
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.