|
|
|
date: Thu, 04 Sep 2008 15:30:15 +0100,
group: microsoft.public.access.forms
back
Re: Default options for forms
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
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mo" wrote in message
news:g9ordo$hmc$1@qmul...
> 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
date: Thu, 4 Sep 2008 23:12:44 +0800
author: Allen Browne lid
Re: Default options for forms
Allen Browne wrote:
> 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.
date: Thu, 04 Sep 2008 16:59:47 +0100
author: Mo
|
|
