Access lets you specify several units of measurement for drawn report objects.

The ScaleMode property defines the unit of measurement for drawn objects, such as lines and circles, on a report. The default setting is 1 (twip). However, you can choose from several other units: 0 (custom setting), 2 (point), 3 (pixel), 4 (character), 5 (inch), 6 (millimeter), and 7 (centimeter).

You might also consider assigning your ScaleMode value as a global integer - it will be easier to keep up with. However, you can set this property only through a Print event. So, while you can define the variable globally, you must call it from a Print event to execute it.

The Cobb Group

If you display a crosstab query as a datasheet, it's best to use a month's or day's number as a column heading instead of a text abbreviation (e.g., 1 instead of Jan or January, or 2 instead of Mon). That's because Access sorts the text abbreviations alphabetically. As a result, Apr appears before Feb, Mon appears before Sun, etc., which can be confusing. In contrast, Access sorts the number representations in their proper numeric order.

Inside Microsoft Office 97