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  

Default control properties (font, size, height, ...)



 
 
Thread Tools Display Modes
  #1  
Old April 22nd, 2008, 03:43 PM posted to microsoft.public.access.forms
Dale Fye
external usenet poster
 
Posts: 2,651
Default Default control properties (font, size, height, ...)

A couple of days ago, I finally figured out (after many years of using
Access) how to change the default properties for controls, so that when I add
a control, it gets created with the font, size, height, and other properties
I want. I cannot believe it took me all these years to figure this out. :-(

I did this in a database I'm working on, but today, these values have
returned to their original numbers. Does changing these values only effect
the current session? Or is there something special I need to do to save they
values so they apply whenever this database is opened? Or is there something
I can do so that they are the same, whenever I use Access?

Dale
--

email address is invalid
Please reply to newsgroup only.

  #2  
Old April 23rd, 2008, 05:47 AM posted to microsoft.public.access.forms
Steve Sanford
external usenet poster
 
Posts: 190
Default Default control properties (font, size, height, ...)

Hi Dale,

I found this in Help:

*About setting defaults for a control type*
------------------------------------------------
snip
Once you reset a control's default control style, all subsequent controls of
that type that you add to the current form or report will have those property
settings.

The default control style remains in effect for *that form or report* until
you change it again. If you want the new settings to apply to all new
controls, you can make the current form or report a template.
snip


and

*About using a template to create a form or report*
-----------------------------------------------------------

When you create a form or report without using a wizard, Microsoft Access
uses a template to define the default characteristics of the form or report.

The template determines which sections a form or report will have and
defines each section's dimensions. The template also contains all the default
property settings for the form or report and its sections and controls.
However, a template doesn't create controls on a new form or report.

The default templates for forms and reports are called Normal. However, you
can use any existing form or report as a template. You can also create a form
or report to use only as a template. Changing the template doesn't have any
effect on existing forms or reports.

Microsoft Access saves the settings for the Form Template and Report
Template options in your Microsoft Access workgroup information file, not in
your Microsoft Access database (the .mdb file) or Microsoft Access project
(the .adp file). When you change an option setting, the change applies to any
Access database or Access project you open or create.

If your templates are not in an Access database or Access project, Microsoft
Access uses the Normal template for any new forms and reports you create.
However, the names of your templates appear in the Form Template and Report
Template options in every Access database or Access project in your database
system, even if the templates are not in every Access database or Access
project.



So I did a little testing:

Create an new blank MDB. Set up a form like you want it, then set up the
defaults for the controls (you don't have to add any controls to the form)
and save the form... I used "DefaultForm".

Under TOOLS/OPTIONS, click on the FORMS/REPORTS and set the default form to
the form you just created ("DefaultForm"). In the database window, right
click on the form (do not open it), then click the "Hidden" attribute. Save
the MDB, naming it something like "DefaultMDB".

When you want/need a new database, copy the "DefaultMDB", then rename it. If
you don't use the wizard to create new forms, any forms you create will have
the form and control defaults like you want them.

Now I have to get busy and set up my defaults. :-)
Thanks for the nudge...

HTH
--
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)


"Dale Fye" wrote:

A couple of days ago, I finally figured out (after many years of using
Access) how to change the default properties for controls, so that when I add
a control, it gets created with the font, size, height, and other properties
I want. I cannot believe it took me all these years to figure this out. :-(

I did this in a database I'm working on, but today, these values have
returned to their original numbers. Does changing these values only effect
the current session? Or is there something special I need to do to save they
values so they apply whenever this database is opened? Or is there something
I can do so that they are the same, whenever I use Access?

Dale
--

email address is invalid
Please reply to newsgroup only.

  #3  
Old April 23rd, 2008, 11:56 AM posted to microsoft.public.access.forms
Dale Fye
external usenet poster
 
Posts: 2,651
Default Default control properties (font, size, height, ...)

Thanks, Steve.


"Steve Sanford" limbim53 at yahoo dot com wrote in message
...
Hi Dale,

I found this in Help:

*About setting defaults for a control type*
------------------------------------------------
snip
Once you reset a control's default control style, all subsequent controls
of
that type that you add to the current form or report will have those
property
settings.

The default control style remains in effect for *that form or report*
until
you change it again. If you want the new settings to apply to all new
controls, you can make the current form or report a template.
snip


and

*About using a template to create a form or report*
-----------------------------------------------------------

When you create a form or report without using a wizard, Microsoft Access
uses a template to define the default characteristics of the form or
report.

The template determines which sections a form or report will have and
defines each section's dimensions. The template also contains all the
default
property settings for the form or report and its sections and controls.
However, a template doesn't create controls on a new form or report.

The default templates for forms and reports are called Normal. However,
you
can use any existing form or report as a template. You can also create a
form
or report to use only as a template. Changing the template doesn't have
any
effect on existing forms or reports.

Microsoft Access saves the settings for the Form Template and Report
Template options in your Microsoft Access workgroup information file, not
in
your Microsoft Access database (the .mdb file) or Microsoft Access project
(the .adp file). When you change an option setting, the change applies to
any
Access database or Access project you open or create.

If your templates are not in an Access database or Access project,
Microsoft
Access uses the Normal template for any new forms and reports you create.
However, the names of your templates appear in the Form Template and
Report
Template options in every Access database or Access project in your
database
system, even if the templates are not in every Access database or Access
project.



So I did a little testing:

Create an new blank MDB. Set up a form like you want it, then set up the
defaults for the controls (you don't have to add any controls to the form)
and save the form... I used "DefaultForm".

Under TOOLS/OPTIONS, click on the FORMS/REPORTS and set the default form
to
the form you just created ("DefaultForm"). In the database window, right
click on the form (do not open it), then click the "Hidden" attribute.
Save
the MDB, naming it something like "DefaultMDB".

When you want/need a new database, copy the "DefaultMDB", then rename it.
If
you don't use the wizard to create new forms, any forms you create will
have
the form and control defaults like you want them.

Now I have to get busy and set up my defaults. :-)
Thanks for the nudge...

HTH
--
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)


"Dale Fye" wrote:

A couple of days ago, I finally figured out (after many years of using
Access) how to change the default properties for controls, so that when I
add
a control, it gets created with the font, size, height, and other
properties
I want. I cannot believe it took me all these years to figure this out.
:-(

I did this in a database I'm working on, but today, these values have
returned to their original numbers. Does changing these values only
effect
the current session? Or is there something special I need to do to save
they
values so they apply whenever this database is opened? Or is there
something
I can do so that they are the same, whenever I use Access?

Dale
--

email address is invalid
Please reply to newsgroup only.



 




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 02:27 PM.


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