Edit the Expression

This Expression is similar to ones we created earlier in various Select Queries. You can edit the text between the quotation marks if you wish.

 

5. Try it: Find the Page Number Properties

The Movies by Genre Report is in Design View and the Page Number Control is selected.

Go to Property Sheet->All.

Click on Control Source.

Click on the 3-Dot Builder.

The Code Builder should open.

 

Try This, Too: Edit the Expression

Type Movies by Genre Report between the quote marks as follows:

 

="Movies by Genre Report: Page " & [Page] & " of " & [Pages]

 

Where the Expression is one sentence without line breaks as may be printed in the preceding paragraph, above.

 

Click OK to close the Expression Builder.

You should return to the Report in Design View.

Report Design Tools->Design->Tools->Property Sheet

Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.2. Apply Report Design options: Insert a Page Break