Quick tips for resizing Access report labels

by Mary Ann Richardson | Jun 06, 2006 7:00:00 AM

Tags: Microsoft Office, Mary Ann Richardson, Microsoft Access, report label, Microsoft Office Suite Access Tips Newsletter

2 comment(s)

Takeaway: Text running over in an Access report label? Don't resize the text�resize the label! This Access tip from Mary Ann Richardson offers quick solutions to resizing report labels for a clean look.

The are a number of possible reasons why the text no longer fits within your Access report label controls. For instance, you may have just changed the fonts of your report labels from 10 to 12 points or the label size picked by the Form Wizard is too small for your labels. While you could spend time dragging one of the sizing handles of each control until it fits the text, there are quicker ways to resize a report label.

Rather than dragging a sizing handle, double-click it instead. This lets Access auto-fit the report label for you. Or, if you have a number of report labels to resize, follow these steps:

Press [Shift] while you select each report label control you want to resize.
Go to Format | Size | To fit.

All the selected report labels will automatically resize to fit the text.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

2 comment(s)