Access Reports. Please help!

  • Thread starter Thread starter Susan Diane
  • Start date Start date
S

Susan Diane

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.
Click to expand...
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?
 
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.
 
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.
 
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 bu
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 dashe
borders?
 
Back
Top