form font global format

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

Hi, I have a table in Arial 11. I've created a form that I would also like to
be in Arial 11, but there is obviously a default set. I can change the
individual fields, but this is tedious. How can I change the global default
for the entire form ?
Access 2003
Many thanks
 
Graham,
Your Table view font is set via Tools - Options - Datasheet

Forms (and reports) use a different method...
For a form design, set up a text control for say... Arial 11, Yellow
Backcolor, Bold.
While that control is selected in Design View, use the Format -
SetControlDefaults to save that format. From now on... on this form, every
Text control added thereafter will have the same characteristics. You could
do this same procedure for your labels, combo boxes, checkboxes, etc.....
OK... you have a form that you designed with the ControlDefaults set for
all your objects. Say that form is called frmCustomers.
Go to Options - Forms/Reports, and put frmCustomers in the Form Template
field.
Now, every new form you design will use the same settings as "set" in
frmCustomer.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Many thanks for your reply. That appears to sort the problem for any
additional 'Controls', or indeed a new Form. However, having alreaady created
a form, with the Control defaults in place, is it now possible to universally
change the Form, or do I have to go through each Control individually ?
Thankyou
 
You can shift-click on each of the controls you want to change and then
apply the change to all of them at once.

Optionally you can select groups of controls by dragging around them and
apply the changes to all of them at once.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Many thanks to you both, now all OK!!

John Spencer said:
You can shift-click on each of the controls you want to change and then
apply the change to all of them at once.

Optionally you can select groups of controls by dragging around them and
apply the changes to all of them at once.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top