ACC2000: Can't Print Datasheet Gridlines in Color in Access
ID: Q207494
|
The information in this article applies to:
This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).
Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
When you set the options for Datasheet view of a table, query, or form on
the Datasheet tab of the Options dialog box (Tools|Options), you can change the color of the gridlines. The color that you select is visible on your screen in Datasheet view; however, if you print or preview the Datasheet, all gridlines are black.
RESOLUTION
If you want to print color gridlines in a Datasheet, you can create a
report based on the table or query that arranges text box controls to
simulate a Datasheet view. Then you can set the properties of the text
boxes to display colored outlines that will print on your color printer.
This example demonstrates how to arrange text boxes on a report to simulate
a Datasheet view:
- Open the sample database Northwind.mdb.
- In the Database window, click Reports under Objects , and then click New.
- In the New Report dialog box, click AutoReport: Tabular, and then click Shippers in the Choose the table or query where the object's data comes from box. Click OK.
- As soon as the report is displayed in Print Preview, on the View menu, click Design View.
- Delete the Line object under the three label controls in the page
header section of the report.
- Click the Shipper ID label control in the page header section, and then hold down the SHIFT key as you click the Company Name and Phone label controls. This selects all three labels at the same time. With
all three controls selected, set the following properties, which will
affect each of the controls:
Top: 0"
BackStyle: Normal
BackColor: 12632256
BorderStyle: Solid
BorderColor: 0
- With all three label controls still selected, on the Format menu, click Horizontal Spacing, and then click Decrease. This decreases the space between the labels. Repeat this step if necessary
until there is no space between the controls.
- Click the ShipperID text box in the detail section, and then hold down the SHIFT key as you click the CompanyName and Phone text boxes. This selects all three text boxes at the same time. With all three controls selected, set the following properties, which will affect each of the controls:
Top: 0"
Height: 0.2"
BorderStyle: Solid
- With all three text box controls still selected, on the Format menu, click Horizontal Spacing, and then click Decrease. This decreases the space between the labels. Repeat this step if necessary
until there is no space between the controls.
- Set the Height property of the detail section to 0.2".
- On the File menu, click Print Preview. Note that the report simulates a Datasheet view of the Shippers table, and you can see the gridlines in color.
MORE INFORMATIONSteps to Reproduce Behavior
- Open the sample database Northwind.mdb.
- On the Tools menu, click Options.
- Click the Datasheet tab in the Options dialog box.
- In the Gridlines box, set the color to Blue, and then click OK.
- Open the Shippers table in Datasheet view. Note that blue gridlines appear.
- On the File menu, click Print Preview.
Note that some or all of the gridlines appear black in Print Preview.
NOTE: If you change the Font or Background colors for the Datasheet, those colors appear correctly when you print or preview the Datasheet.
REFERENCESFor more information about default options, click Microsoft Access Help on the
Help menu, type "Customize the Microsoft Access environment by setting defaults" in the Office Assistant or the Answer Wizard,
and then click Search to view the topic.
For more information about customizing gridlines, click Microsoft Access Help on the
Help menu, type "Change the gridline style and background color in Datasheet view" in the Office Assistant or the Answer Wizard,
and then click Search to view the topic.
Additional query words:
grid line
Keywords : kbusage kbdta PtrOthr UifDatash
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb
|