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.

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.

.

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.

.

.

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.

.

.

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.

.

.


.

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?