Business Solutions Tricks of the Microsoft Office 2007 Gurus

15. Form and Report Tricks

IN THIS CHAPTER

Opening a Form Automatically When You Load a Database

Automatically Moving to the Last Record When You Open a Form

Creating a Switchboard Form

Using a Toggle Button for a Yes/No Field

Preventing Changes to the Form’s Data Source

Customizing the Form’s Tab Order

Creating Shortcut Keys for Form Controls

Applying Formatting to Special Form Values

Creating Calculated Form Controls

Creating Custom Report Groups

Inserting Page Numbers in the Report

Inserting the Current Date in a Report

Adding Page Breaks after Report Sections

Preventing Widowed Report Records

Starting Report Sections at the Top of a Row or Column

Creating a Multiple-Column Report

Creating Mailing Labels

Distributing a Report Snapshot