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. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|