Thanks for the additional input. I understand what you’re saying. I
appreciate you sharing your experience.
"Marshall Barton" wrote:
> 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]
>
>
> AccessKay wrote:
> >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" wrote:
> >> AccessKay wrote:
> >> >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.
> .
>
|