Tech Tip: Override automatic page breaks in Word/Convert a chart to a picture in Excel/Control data entry using an Access form's properties

Find out how to prevent Word from inserting page breaks, create a chart that doesn't reflect changes to data, and protect data from inadvertent edits, deletions, or additions in Access.

Override automatic page breaks

By default, Word creates a new page break when the text reaches the bottom margin. However, sometimes you may want to override automatic pagination to ensure the specific placement of paragraphs on a page.

For example, let's say you have a paragraph that you don't want Word to separate between pages. To prevent Word from inserting a page break within the paragraph, follow these steps:

  1. Select the paragraph, and go to Format | Paragraph.
  2. On the Line And Page Breaks tab, select the Keep Lines Together check box, and click OK.

When you select this option, Word won't break the paragraph. Rather than splitting it up, Word will move the entire paragraph to the next page.

You can also use this feature to keep two paragraphs together on the same page. In this case, select the first paragraph, and select the Keep With Next check box instead of Keep Lines Together. This ensures that the selected paragraph will always appear on the same page as the paragraph that follows it.

Convert a chart to a picture

By default, Excel links all chart data to the chart. When you make a change to the data, the chart changes to reflect the new data.

There are times, however, when you may want to create a chart that doesn't change, which represents the data from a particular point in time. One method for creating such a chart is to convert the chart to a picture.

To convert a chart to a picture, follow these steps:

  1. Open the chart you want to convert, and select the chart.
  2. Press [Shift], and go to Edit | Copy Picture.
  3. In the Copy Picture dialog box, select As Shown When Printed in the Appearance section.
  4. In the Size section, select As Shown On Screen, and click OK.
  5. Click the cell where you want to place the picture of your chart.
  6. Go to Edit | Paste.

Now when you change data in the spreadsheet, the original chart will change, but the converted chart will remain the same.

Control data entry using a form's properties

The properties of a form can help protect your data from inadvertent edits, deletions, or additions. If you want to use a form only as a resource to look things up, you can set the form's data properties to allow read-only access.

Follow these steps:

  1. Open the form in Design View, and click the Form Properties button on the Form Design toolbar.
  2. On the Data tab, change the Allow Edits property to No.
  3. Change the Allow Deletions property to No.
  4. Changed the Allow Additions property to No.

Editor's Picks

Free Newsletters, In your Inbox