Choosing Report Format-Need advice

[AccessKay]

I asked this similar question a few days ago but received no response. Is
there a way to change the properties when you’re using an AutoFormat for a
report? I tried unsuccessfully to change the height of my alternating
background when I used an AutoFormat (I’m using Access 2007). Is this the
“rule� I’m about to create several end-of-the-month reports that I plan to
pull each month and thought I’d ask before I started. I’m also welcome to
any suggestions about AutoFormat vs. designing your own report.

Thank you for your input.

 

[Marshall Barton]

I asked this similar question a few days ago but received no response. Is
there a way to change the properties when you’re using an AutoFormat for a
report? I tried unsuccessfully to change the height of my alternating
background when I used an AutoFormat (I’m using Access 2007). Is this the
“rule”? I’m about to create several end-of-the-month reports that I plan to
pull each month and thought I’d ask before I started. I’m also welcome to
any suggestions about AutoFormat vs. designing your own report.

I don't use such things as AutoFormat or report wizards
because they are too limited.

Everything that can be done with a report can be done in
design view.

The height of your alternating colors is the height of the
detail section. In design view you can adjust the height of
individual controls (text box, etc) and the height of the
sections (Detail, etc) to get the specific height you want.

 

[AccessKay]

Thanks for your reply. I suspected to hear this opinion. I don't want to be
limited and will take your advice to create my own.

 

[Marshall Barton]

It's not a night and day decision. There are times when
using a form/report wizard or whatever is convenient to get
things started. But all the fine tuning and future changes
need to be done in design view. After you get a fair amount
of experience in design view, you will likely find yourself
using the form/report wizards less and less.

I still use the query designer with or without a wizard's
help to get the general stuff for a query's SQL. For simple
queries, that may be all you need, but for less simple
queries, switch to SQL view where all the features of
queries are available.

 

[AccessKay]

Thanks for the additional input. I understand what you’re saying. I
appreciate you sharing your experience.

It's not a night and day decision. There are times when
using a form/report wizard or whatever is convenient to get
things started. But all the fine tuning and future changes
need to be done in design view. After you get a fair amount
of experience in design view, you will likely find yourself
using the form/report wizards less and less.

I still use the query designer with or without a wizard's
help to get the general stuff for a query's SQL. For simple
queries, that may be all you need, but for less simple
queries, switch to SQL view where all the features of
queries are available.
--
Marsh
MVP [MS Access]

Thanks for your reply. I suspected to hear this opinion. I don't want to be
limited and will take your advice to create my own.

.