Default options for forms

[Mo]

Hello,

I'd like to change some of the default properties of my forms. Firstly,
how do I change the default font that Access uses (is it Tahoma?) to
something a bit more acceptable, e.g. Arial.

Secondly, when I place a text box on a form, the text in the label bound
to the testbox has a colon after it (e.g. 'surname:'). Can I also change
this behaviour? I've searched in the options menu, but I can't find out
how to change these simple, but annoying things.

I'm using Access 2003 P3.

TIA

Mo

 

[Allen Browne]

It's not particularly obvious, but you can set the properties of the items
in the Toolbox. That sets them for a particular form. Then if you save that
form as a template, you get your preferences on new forms as well.

1. Create a new form. No table. Design View (i.e. don't step through the
wizards.)

2. In form design view, open the Toolbox, and the Properties box.

3. In the Toolbox, click on the text box.
The title of the Properties box now reads, "Default Text Box."

4. Set the properties you want, such as the Font Name.
Set the Add Colon property to No if you don't want the colon.

5. Set the properties for other objects in the Toolbox as well, such as
labels and combos.

6. Set the properties you want for the form itself, e.g. setting Allow
Design Changes to "Design View Only" so the Properties box won't open up
when you are actually using the form.

7. Save the form with a name such as frmTemplate.
This form will retain these properties, and use them if you add any text
box, label, etc.

8. Specify this form as the template for creating new forms:
Tools | Options | Forms/Reports.

Repeat the process to create a template report if desired.

For more information, see:
Default forms, reports and databases
at:
http://allenbrowne.com/ser-43.html

 

[Mo]

It's not particularly obvious, but you can set the properties of the
items in the Toolbox. That sets them for a particular form. Then if you
save that form as a template, you get your preferences on new forms as
well.

1. Create a new form. No table. Design View (i.e. don't step through the
wizards.)

2. In form design view, open the Toolbox, and the Properties box.

3. In the Toolbox, click on the text box.
The title of the Properties box now reads, "Default Text Box."

4. Set the properties you want, such as the Font Name.
Set the Add Colon property to No if you don't want the colon.

5. Set the properties for other objects in the Toolbox as well, such as
labels and combos.

6. Set the properties you want for the form itself, e.g. setting Allow
Design Changes to "Design View Only" so the Properties box won't open up
when you are actually using the form.

7. Save the form with a name such as frmTemplate.
This form will retain these properties, and use them if you add any text
box, label, etc.

8. Specify this form as the template for creating new forms:
Tools | Options | Forms/Reports.

Repeat the process to create a template report if desired.

For more information, see:
Default forms, reports and databases
at:
http://allenbrowne.com/ser-43.html

Brilliant! Thanks very much Allen.