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
|
|||
|
|||
Access Reports. Please help!
I am posting this again since I haven't gotten a reply. I have several complex reports set to print in snapshot format. Intermittently, there is a single line in the detail section which is divided between two pages so that the top of the entire line is on one page and the bottom of the line is on another making the line unreadable. I have gone over the alignment and made all controls on the same line the same size. I tried changing the option on the labels and textboxes to "size to fit" as suggested by a reader when I initially posted the problem. The problem can be fixed by going to page setup and changing the top or bottom margin for an individual report but because the report has a variable size this does not fix the problem for all reports. The reports all have report headers, page headers, detail sections, page footer, report footer. I searched the knowledge base and cannot find a description of this problem. Can anyone tell me what I am doing wrong? I have a large number of people using the database and changing the page setup when the report is printed incorrectly won't work as a long term solution.
|
#2
|
|||
|
|||
Access Reports. Please help!
You may want to look at the "Can Grow" property on both
the fields on the report and the detail section. You can make the field small and if it has no data it will stay that size, otherwise it grows to fit whatever is in it. Just an idea... hope it helps Susan -----Original Message----- I am posting this again since I haven't gotten a reply. I have several complex reports set to print in snapshot format. Intermittently, there is a single line in the detail section which is divided between two pages so that the top of the entire line is on one page and the bottom of the line is on another making the line unreadable. I have gone over the alignment and made all controls on the same line the same size. I tried changing the option on the labels and textboxes to "size to fit" as suggested by a reader when I initially posted the problem. The problem can be fixed by going to page setup and changing the top or bottom margin for an individual report but because the report has a variable size this does not fix the problem for all reports. The reports all have report headers, page headers, detail sections, page footer, report footer. I searched the knowledge base and cannot find a description of this problem. Can anyone tell me what I am doing wrong? I have a large number of people using the database and changing the page setup when the report is printed incorrectly won't work as a long term solution. . |
#3
|
|||
|
|||
Access Reports. Please help!
I need the can grow property to be true for textbox
because the content varies in size. I can understand why there is a variable number of pages but why does the top part of a single line appear on one page and the bottom part of the line appear on the next page instead of starting the line that will not fit vertically on the next page. Is there something unusual about the way that a snapshot report wraps text? -----Original Message----- You may want to look at the "Can Grow" property on both the fields on the report and the detail section. You can make the field small and if it has no data it will stay that size, otherwise it grows to fit whatever is in it. Just an idea... hope it helps Susan -----Original Message----- I am posting this again since I haven't gotten a reply. I have several complex reports set to print in snapshot format. Intermittently, there is a single line in the detail section which is divided between two pages so that the top of the entire line is on one page and the bottom of the line is on another making the line unreadable. I have gone over the alignment and made all controls on the same line the same size. I tried changing the option on the labels and textboxes to "size to fit" as suggested by a reader when I initially posted the problem. The problem can be fixed by going to page setup and changing the top or bottom margin for an individual report but because the report has a variable size this does not fix the problem for all reports. The reports all have report headers, page headers, detail sections, page footer, report footer. I searched the knowledge base and cannot find a description of this problem. Can anyone tell me what I am doing wrong? I have a large number of people using the database and changing the page setup when the report is printed incorrectly won't work as a long term solution. . . |
#4
|
|||
|
|||
Access Reports. Please help!
Do you have settings other than zero in the Margin props for the
TextBoxes involved? Do you have a solid border, versus dotted or dashed for the border of the TextBox control? -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. wrote in message ... I need the can grow property to be true for textbox because the content varies in size. I can understand why there is a variable number of pages but why does the top part of a single line appear on one page and the bottom part of the line appear on the next page instead of starting the line that will not fit vertically on the next page. Is there something unusual about the way that a snapshot report wraps text? -----Original Message----- You may want to look at the "Can Grow" property on both the fields on the report and the detail section. You can make the field small and if it has no data it will stay that size, otherwise it grows to fit whatever is in it. Just an idea... hope it helps Susan -----Original Message----- I am posting this again since I haven't gotten a reply. I have several complex reports set to print in snapshot format. Intermittently, there is a single line in the detail section which is divided between two pages so that the top of the entire line is on one page and the bottom of the line is on another making the line unreadable. I have gone over the alignment and made all controls on the same line the same size. I tried changing the option on the labels and textboxes to "size to fit" as suggested by a reader when I initially posted the problem. The problem can be fixed by going to page setup and changing the top or bottom margin for an individual report but because the report has a variable size this does not fix the problem for all reports. The reports all have report headers, page headers, detail sections, page footer, report footer. I searched the knowledge base and cannot find a description of this problem. Can anyone tell me what I am doing wrong? I have a large number of people using the database and changing the page setup when the report is printed incorrectly won't work as a long term solution. . . |
#5
|
|||
|
|||
Access Reports. Please help!
The margins are all set at zero. Some of the text boxes
do have solid borders, most of the text boxes have transparent borders. The problem seems to happen with lines from the subreports but since there are a large number of subreports this may be a coincidence. -----Original Message----- Do you have settings other than zero in the Margin props for the TextBoxes involved? Do you have a solid border, versus dotted or dashed for the border of the TextBox control? -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. wrote in message ... I need the can grow property to be true for textbox because the content varies in size. I can understand why there is a variable number of pages but why does the top part of a single line appear on one page and the bottom part of the line appear on the next page instead of starting the line that will not fit vertically on the next page. Is there something unusual about the way that a snapshot report wraps text? -----Original Message----- You may want to look at the "Can Grow" property on both the fields on the report and the detail section. You can make the field small and if it has no data it will stay that size, otherwise it grows to fit whatever is in it. Just an idea... hope it helps Susan -----Original Message----- I am posting this again since I haven't gotten a reply. I have several complex reports set to print in snapshot format. Intermittently, there is a single line in the detail section which is divided between two pages so that the top of the entire line is on one page and the bottom of the line is on another making the line unreadable. I have gone over the alignment and made all controls on the same line the same size. I tried changing the option on the labels and textboxes to "size to fit" as suggested by a reader when I initially posted the problem. The problem can be fixed by going to page setup and changing the top or bottom margin for an individual report but because the report has a variable size this does not fix the problem for all reports. The reports all have report headers, page headers, detail sections, page footer, report footer. I searched the knowledge base and cannot find a description of this problem. Can anyone tell me what I am doing wrong? I have a large number of people using the database and changing the page setup when the report is printed incorrectly won't work as a long term solution. . . . |
#6
|
|||
|
|||
Access Reports. Please help!
The margins are all set at zero. Some of the text boxes
do have solid borders, most of the text boxes have transparent borders. The problem seems to happen with lines from the subreports which only have transparent borders but since there are a large number of subreports this may be a coincidence. Should I try to change the textboxes with solid borders to dotted or dashed borders? |
Thread Tools | |
Display Modes | |
|
|