Wizard and "Normal"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Somewhere I read that u could save a report, or form, named "normal" and when
u had the wizard create a new report or form it would have the fonts, colors
etc of that "normal" report or form.

I have never been able to get this to work. I always get that ugly
TimesNewRoman font in blue and spend time changing it around.

Did I make this feature up or am i doing something wrong?
 
You can use a form or report of your own design as the default template.
They do not have to be named "normal". Enter the actual name of your
template from and report in the fields on the Tools | Options |
Forms/Reports tab.

To make this work properly, though, you also need to set the default
properties for the various controls to what you want them to be. Do this by
selecting the control in the toolbox (do NOT select a specific instance of
that type of control on a form/report - the heading of the Properties box
should say, for example, "Default Text Box)

You can change as few/many of the control properties as you want. Your
template form/report does not need to have any controls on it. You can do
things like set different colours for form header, detail and footer
sections (something which I generally want by default), set font styles,
sizes, colours, attached labels, tab stops - whatever you need.

Unfortunately, you cannot get Access to stop naming bound controls with the
same name as their recordsource :-(

Rob
 
When you create the report where do you store it at?? I tried this and I
wasn't given an option of my template.. Do you have to name it with a
special .XXX??

thanks
R~
 
Your initial post asked about setting defaults for things like colours,
fonts, etc. I assume that this is what you want. To do this, simply open a
new report in design mode, set the default values of the controls set to how
you want them, then save the report - there is no template option available
(or required!). It does not have to have any visible controls in it (and,
if it does, they won't appear in other new reports). You can give it any
name you want - I use something like zrptTemplate, which (unless I change
the sort order or field) makes it appear at the bottom of the list in the
Reports tab of the database window. Enter the name you use in the
appropriate field on the Tools | Options | Forms/Reports tab.

If you want to set up a report template which acts more like a .dot in Word,
you can design a report with standard elements you want to appear on all
your reports (eg. textbox formatted for title in report header, date/time
and page numbers in page footer, etc). To use this, you simply copy it and
rename it when you want to generate a new report containing your standard
features.

HTH,

Rob
 
Rob...

Thank you for the tip... I found this post on a search and wanted to see
if I was missing a step when trying to create a template for the reports...

Thanks again!
R~
 
Back
Top