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 said:
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.
