A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Choosing Report Format-Need advice



 
 
Thread Tools Display Modes
  #1  
Old May 7th, 2010, 10:34 PM posted to microsoft.public.access.reports
AccessKay
external usenet poster
 
Posts: 106
Default Choosing Report Format-Need advice

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.

  #2  
Old May 8th, 2010, 12:08 AM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Choosing Report Format-Need advice

AccessKay wrote:

I asked this similar question a few days ago but received no response. Is
there a way to change the properties when youre using an AutoFormat for a
report? I tried unsuccessfully to change the height of my alternating
background when I used an AutoFormat (Im using Access 2007). Is this the
rule? Im about to create several end-of-the-month reports that I plan to
pull each month and thought Id ask before I started. Im 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]
  #3  
Old May 10th, 2010, 04:01 PM posted to microsoft.public.access.reports
AccessKay
external usenet poster
 
Posts: 106
Default Choosing Report Format-Need advice

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]
.

  #4  
Old May 10th, 2010, 05:27 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Choosing Report Format-Need advice

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 youre using an AutoFormat for a
report? I tried unsuccessfully to change the height of my alternating
background when I used an AutoFormat (Im using Access 2007). Is this the
rule? Im about to create several end-of-the-month reports that I plan to
pull each month and thought Id ask before I started. Im 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.

  #5  
Old May 10th, 2010, 07:29 PM posted to microsoft.public.access.reports
AccessKay
external usenet poster
 
Posts: 106
Default Choosing Report Format-Need advice

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.

.

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.