A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Customise Autoformat in Access 2007



 
 
Thread Tools Display Modes
  #1  
Old September 19th, 2009, 01:15 PM posted to microsoft.public.access.forms
Tony Williams[_2_]
external usenet poster
 
Posts: 169
Default Customise Autoformat in Access 2007

I want to customise a form format under the Autoformat option in Access 2007.
However when I click on the Customise button it doesn't allow me to edit the
font size or colour. How do I do this? Itried changing the font size of a
control on the current form and then chosing the option to create a new style
based on the form but it didn't hold the new font size to all the controls
when I tried to apply it to other forms.
Alternatively how do i create a design that I can use to create a style in
Auto format so that I can can change all my existing forms to the new style?
Thanks
Tony
  #2  
Old September 19th, 2009, 08:53 PM posted to microsoft.public.access.forms
TonyT
external usenet poster
 
Posts: 154
Default Customise Autoformat in Access 2007

I got fed up very quickly playing with the format features in 2007, so went
back to the old way of creating a 'master' form with all controls and form
layout as I want it, then save that form as frmZDesign (so it;s always at the
bottom) and then rather than creating a new form I open that one, click Save
As to give it the name i want, set control defaults, then delete all the
existing controls and continue from there.

Although I have noticed that 2007 crashes about 1 in 10 times when I do this
routine. I'm fairly sure it happens when I set defaults and delete the
existing controls without saving in between times. At least it hasn't crashed
since I started saving between the 2 actions.

"Tony Williams" wrote:

I want to customise a form format under the Autoformat option in Access 2007.
However when I click on the Customise button it doesn't allow me to edit the
font size or colour. How do I do this? Itried changing the font size of a
control on the current form and then chosing the option to create a new style
based on the form but it didn't hold the new font size to all the controls
when I tried to apply it to other forms.
Alternatively how do i create a design that I can use to create a style in
Auto format so that I can can change all my existing forms to the new style?
Thanks
Tony

  #3  
Old September 20th, 2009, 09:39 AM posted to microsoft.public.access.forms
Tony Williams[_2_]
external usenet poster
 
Posts: 169
Default Customise Autoformat in Access 2007

Thanks Tony, maybe I'll end up trying to do something along those lines.
Thanks again for the tip.
Tony

"TonyT" wrote:

I got fed up very quickly playing with the format features in 2007, so went
back to the old way of creating a 'master' form with all controls and form
layout as I want it, then save that form as frmZDesign (so it;s always at the
bottom) and then rather than creating a new form I open that one, click Save
As to give it the name i want, set control defaults, then delete all the
existing controls and continue from there.

Although I have noticed that 2007 crashes about 1 in 10 times when I do this
routine. I'm fairly sure it happens when I set defaults and delete the
existing controls without saving in between times. At least it hasn't crashed
since I started saving between the 2 actions.

"Tony Williams" wrote:

I want to customise a form format under the Autoformat option in Access 2007.
However when I click on the Customise button it doesn't allow me to edit the
font size or colour. How do I do this? Itried changing the font size of a
control on the current form and then chosing the option to create a new style
based on the form but it didn't hold the new font size to all the controls
when I tried to apply it to other forms.
Alternatively how do i create a design that I can use to create a style in
Auto format so that I can can change all my existing forms to the new style?
Thanks
Tony

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.