Normal Template for Forms/Reports

[Guest]

This is not a very technical one but it would help me if I could change the default properties of the Normal Template for Reports and Forms. I end up changing the font and default font size with every form/report I create to be consistent throughout the database. Your help would be greatly appreciated.
Dan Sweetwood

 

[Fred Boer]

I thought about answering, but Allen Browne's answer (which I found via a
Google groups search...) is much better than mine would have been!

Quote begins:

To set the properties for the default text box for a form:
1. Open the form in design view.
2. Open the Properties box (View menu).
3. Open the Toolbox (View menu).
4. Select the Text Box in the Toolbox.
5. Set the Font Size in the Properties box.

This sets the default font size for the text box on that form. Repeat for
Label, Combo, etc.

You can then save this form (doesn't need a RecordSource or any controls).
Then name this file under:
Tools | Options | Forms/Reports | Form Template
The properties then apply to other forms created in the future.

More information and suggestions in article:
Default forms and reports
at:
http://allenbrowne.com/ser-43.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Quote ends

Besides... his link about "Default forms and reports" is one I've missed,
and it looks interesting!

HTH
Fred Boer

This is not a very technical one but it would help me if I could change

the default properties of the Normal Template for Reports and Forms. I end
up changing the font and default font size with every form/report I create
to be consistent throughout the database. Your help would be greatly
appreciated.

 

[tina]

oho, way cool. i went to the link you provided to Allen's webpage - even
cooler!
i went one step further, and first created a DefaultDb.mdb. then i went to
Tools, Options, General tab and unchecked the Name Auto Correct options, and
checkmarked Compact On Close.
then i built a default standard module, default Single/Continuous/Datasheet
forms and a default report...all as per Allen's recommendations. to start a
new db now, i just copy/paste the original in Windows Explorer - my default
objects/settings are ready to go, and that horrid name auto correct feature
is already OFF!
great help from Allen, and from you too Fred - i had no idea you could set
default settings for form/report controls. and thanks so much for posting
that link!
one additional note:
only problem i had was using the public function for the report's OnNoData
event, as

=NoData([Report])

i copied the function from Allen's webpage. Access just refused to recognize
[Report], even though i used it in the calculated textbox control in the
report header per instructions, as

=[Report].[Caption]

and it worked fine there. so i changed the public function to reference
CodeContextObject, calling it as

=NoData()

then Access erred on the function name. so i changed that, as

=isNoData()

changing the name in the module too, of course. now it works fine. but i'm
wondering why it didn't work with the original specifications. perhaps i did
something wrong? i'm using A2003 with A2000 format, on Win2000Pro OS. any
comments appreciated - Fred? Allen? anybody else? thx!

 

[Fred Boer]

Dear Tina:

Well, I tried it and it seemed to work for me without a problem... If I set
the data source for the report to a blank table, the custom error message
comes up nicely. Unfortunately, I'm no expert, so I'm not sure what to
suggest.

If you like, you could send me your blank mdb template, and I could compare
it to mine...
Send it to (e-mail address removed) (removing the munging
words, of course...)

Cheers!
Fred

oho, way cool. i went to the link you provided to Allen's webpage - even
cooler!
i went one step further, and first created a DefaultDb.mdb. then i went to
Tools, Options, General tab and unchecked the Name Auto Correct options, and
checkmarked Compact On Close.
then i built a default standard module, default Single/Continuous/Datasheet
forms and a default report...all as per Allen's recommendations. to start a
new db now, i just copy/paste the original in Windows Explorer - my default
objects/settings are ready to go, and that horrid name auto correct feature
is already OFF!
great help from Allen, and from you too Fred - i had no idea you could set
default settings for form/report controls. and thanks so much for posting
that link!
one additional note:
only problem i had was using the public function for the report's OnNoData
event, as

=NoData([Report])

i copied the function from Allen's webpage. Access just refused to recognize
[Report], even though i used it in the calculated textbox control in the
report header per instructions, as

=[Report].[Caption]

and it worked fine there. so i changed the public function to reference
CodeContextObject, calling it as

=NoData()

then Access erred on the function name. so i changed that, as

=isNoData()

changing the name in the module too, of course. now it works fine. but i'm
wondering why it didn't work with the original specifications. perhaps i did
something wrong? i'm using A2003 with A2000 format, on Win2000Pro OS. any
comments appreciated - Fred? Allen? anybody else? thx!

I thought about answering, but Allen Browne's answer (which I found via a
Google groups search...) is much better than mine would have been!

Quote begins:

To set the properties for the default text box for a form:
1. Open the form in design view.
2. Open the Properties box (View menu).
3. Open the Toolbox (View menu).
4. Select the Text Box in the Toolbox.
5. Set the Font Size in the Properties box.

This sets the default font size for the text box on that form. Repeat for
Label, Combo, etc.

You can then save this form (doesn't need a RecordSource or any controls).
Then name this file under:
Tools | Options | Forms/Reports | Form Template
The properties then apply to other forms created in the future.

More information and suggestions in article:
Default forms and reports
at:
http://allenbrowne.com/ser-43.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Quote ends

Besides... his link about "Default forms and reports" is one I've missed,
and it looks interesting!

HTH
Fred Boer



change
the default properties of the Normal Template for Reports and Forms. I end
up changing the font and default font size with every form/report I create
to be consistent throughout the database. Your help would be greatly
appreciated.

 

[tina]

thanks, fred.
i almost took you up on that, then decided to test it one more time.
naturally, this morning it works just fine with allen's original code. so
who knows what i did last night; or else A2003 is exhibiting the same sort
of instability that used to plague A95 - perish the thought! <cringe>

Dear Tina:

Well, I tried it and it seemed to work for me without a problem... If I set
the data source for the report to a blank table, the custom error message
comes up nicely. Unfortunately, I'm no expert, so I'm not sure what to
suggest.

If you like, you could send me your blank mdb template, and I could compare
it to mine...
Send it to (e-mail address removed) (removing the munging
words, of course...)

Cheers!
Fred

oho, way cool. i went to the link you provided to Allen's webpage - even
cooler!
i went one step further, and first created a DefaultDb.mdb. then i went to
Tools, Options, General tab and unchecked the Name Auto Correct options, and
checkmarked Compact On Close.
then i built a default standard module, default Single/Continuous/Datasheet
forms and a default report...all as per Allen's recommendations. to

start

a
new db now, i just copy/paste the original in Windows Explorer - my default
objects/settings are ready to go, and that horrid name auto correct feature
is already OFF!
great help from Allen, and from you too Fred - i had no idea you could set
default settings for form/report controls. and thanks so much for posting
that link!
one additional note:
only problem i had was using the public function for the report's OnNoData
event, as

=NoData([Report])

i copied the function from Allen's webpage. Access just refused to recognize
[Report], even though i used it in the calculated textbox control in the
report header per instructions, as

=[Report].[Caption]

and it worked fine there. so i changed the public function to reference
CodeContextObject, calling it as

=NoData()

then Access erred on the function name. so i changed that, as

=isNoData()

changing the name in the module too, of course. now it works fine. but i'm
wondering why it didn't work with the original specifications. perhaps i did
something wrong? i'm using A2003 with A2000 format, on Win2000Pro OS. any
comments appreciated - Fred? Allen? anybody else? thx!

I thought about answering, but Allen Browne's answer (which I found

via

a

 

[Fred Boer]

Glad it is working for you!

Fred

thanks, fred.
i almost took you up on that, then decided to test it one more time.
naturally, this morning it works just fine with allen's original code. so
who knows what i did last night; or else A2003 is exhibiting the same sort
of instability that used to plague A95 - perish the thought! <cringe>

Dear Tina:

Well, I tried it and it seemed to work for me without a problem... If I set
the data source for the report to a blank table, the custom error message
comes up nicely. Unfortunately, I'm no expert, so I'm not sure what to
suggest.

If you like, you could send me your blank mdb template, and I could compare
it to mine...
Send it to (e-mail address removed) (removing the munging
words, of course...)

Cheers!
Fred

went

to

Tools, Options, General tab and unchecked the Name Auto Correct

options,
and

checkmarked Compact On Close.
then i built a default standard module, default Single/Continuous/Datasheet
forms and a default report...all as per Allen's recommendations. to

start

a
new db now, i just copy/paste the original in Windows Explorer - my default
objects/settings are ready to go, and that horrid name auto correct feature
is already OFF!
great help from Allen, and from you too Fred - i had no idea you could set
default settings for form/report controls. and thanks so much for posting
that link!
one additional note:
only problem i had was using the public function for the report's OnNoData
event, as

=NoData([Report])

i copied the function from Allen's webpage. Access just refused to recognize
[Report], even though i used it in the calculated textbox control in the
report header per instructions, as

=[Report].[Caption]

and it worked fine there. so i changed the public function to reference
CodeContextObject, calling it as

=NoData()

then Access erred on the function name. so i changed that, as

=isNoData()

changing the name in the module too, of course. now it works fine. but i'm
wondering why it didn't work with the original specifications. perhaps

i
did

something wrong? i'm using A2003 with A2000 format, on Win2000Pro OS. any
comments appreciated - Fred? Allen? anybody else? thx!


I thought about answering, but Allen Browne's answer (which I found

via

a
Google groups search...) is much better than mine would have been!

Quote begins:

To set the properties for the default text box for a form:
1. Open the form in design view.
2. Open the Properties box (View menu).
3. Open the Toolbox (View menu).
4. Select the Text Box in the Toolbox.
5. Set the Font Size in the Properties box.

This sets the default font size for the text box on that form.

Repeat
for

Label, Combo, etc.

You can then save this form (doesn't need a RecordSource or any controls).
Then name this file under:
Tools | Options | Forms/Reports | Form Template
The properties then apply to other forms created in the future.

More information and suggestions in article:
Default forms and reports
at:
http://allenbrowne.com/ser-43.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Quote ends

Besides... his link about "Default forms and reports" is one I've missed,
and it looks interesting!

HTH
Fred Boer



This is not a very technical one but it would help me if I could change
the default properties of the Normal Template for Reports and Forms.

I
end

up changing the font and default font size with every form/report I create
to be consistent throughout the database. Your help would be greatly
appreciated.
Dan Sweetwood

 

[Joan Wild]

, and checkmarked Compact On Close.

You may want to reconsider that. Read the following post, particularly the
last paragraph.

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&[email protected]

 

[tina]

thanks for the update, Joan!

You may want to reconsider that. Read the following post, particularly the
last paragraph.

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&[email protected]

 

[Fred Boer]

Dear Joan:

I hadn't actually heard about that problem until now, and I've always
checked Compact on Close for everything. I guess I better change that!
Thanks for the warning!

Fred Boer