UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> Form and Report Templates    
Form and Report Templates

Contents

Overview

Each form or report you create in Access has a standard set of properties. If you typically modify new forms by changing some of the property settings then you may be able to save some time by creating your own alternative default template. For example, if you prefer to have forms without the Record Selector, rather than changing this property every time you create a new form, you can create your own default form with the Record Selectors property set to No. After you have the custom default form in place, each new form will be created with the Record Selectors set to No instead of yes.

Similarly you can create your own default Report template. For example, Access 2010 reports by default have alternating background colours for the detail section. If you set the Alternate Background Color property to No Color in your custom template, every new report you create after that will have only one colour for the background of the Detail section.

Form Template

First, determine what property settings you want to be standard for every form you create in the application. Create a new Form in design view. Open the property sheet and modify the properties you want to change from the standard default. Then save the new form with the name "Normal." You won't actually use this form in your application but as long as there is a Form named normal, new forms will inherit its property settings.

Report Template

First, determine what property settings you want to be standard for every report you create in the application. Create a new Report in design view. Open the property sheet and modify the properties you want to change from the standard defualt. Then save the new report with the name "Normal." You won't actually use this report in your application but as long as there is a Report named normal, new reports will inherit its property settings.

Controls

You can also modify the default property settings for controls. You will need to be in design view, so open your Normal form or Normal report in design view. You won't be adding any controls to the form or report but you need to be able to see the design tools. First, open the property sheet and either your Normal form or Normal report in design view. Click the control in the design tools that you want to modify (but don't add the control to the form or report.) If you click the textbox control, then the property sheet heading should read "Default Text Box". Modify the properties you want to change. Then close and save Normal. New forms and reports will have controls with the default properties you created in the respective Normal template.

Note: If you have a form (other than Normal) or report (other than Normal) open in design view, you can set defaults for controls that will apply to just that form or report. This may be useful if you are creating a report which will use several controls that you want to have identical properties (Can Grow = Yes, for example.) Not all properties are available when you use this technique but it is worthwhile trying before you start adding controls to the new form or report.

Custom New Database

If you want to use your new Form and Report templates as a standard in all new databases you create, build them and customize their controls in a blank database that you save as your default new database template. See this FAQA for details on creating a default database template.

Edit Discussion
Custom Search
Thank you for your support!
This page has been accessed 13,076 times.  This page was last modified 12:32, 13 May 2013 by Glenn Lloyd. Contributions by tina t  Disclaimers