PC Review


Reply
Thread Tools Rate Thread

Choosing Report Format-Need advice

 
 
AccessKay
Guest
Posts: n/a
 
      7th May 2010
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.

 
Reply With Quote
 
 
 
 
AccessKay
Guest
Posts: n/a
 
      10th May 2010
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.
>
> --
> Marsh
> MVP [MS Access]
> .
>

 
Reply With Quote
 
AccessKay
Guest
Posts: n/a
 
      10th May 2010
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.

> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need advice on choosing CPU needhelp DIY PC 2 7th Jul 2008 02:16 AM
Advice choosing parts Please Vaughn DIY PC 1 1st Jan 2006 04:57 PM
Need advice on choosing template... =?Utf-8?B?cGF1bGIxMDQ=?= Microsoft Access Getting Started 1 25th Jun 2005 09:45 PM
Advice on choosing graphics cards John Carlyle-Clarke Video Cards 0 29th Nov 2004 03:00 PM
advice on choosing right control Mark Siffer Microsoft ASP .NET 1 17th Jun 2004 07:26 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:48 PM.