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  

Extra blank line on report



 
 
Thread Tools Display Modes
  #1  
Old January 6th, 2010, 07:51 PM posted to microsoft.public.access.reports
Bob Howard
external usenet poster
 
Posts: 71
Default Extra blank line on report

Access 2003...

I have a report with a group header and detail lines.

The group header has a fixed size, and set to neither grow nor shrink. The
bottom-most control in the group header is a horizontal line (to set it
apart from the details that follow).

The detail contains one row of controls, but one of these is set so it can
grow (in case the text doesn't fit on the single line). The detail section
itself is set to shrink, but NOT to grow. Some of the controls have "Hide
Duplicates" set to yes ... but I don't see what this has to do with the
problem.

Here's what happens: Between the group header and the first detail line, I
always get what appears to be a single blank line. This appears immediately
following the header's horizontal line and the first line of the detail
section. There's only one blank line ... not one before each detail line.

And this occurs for EVERY group header (and its details) in the entire
report.

I've checked the sizes and other attributes of the controls, etc., and can
find nothing wrong!

Any clues??

bob


  #2  
Old January 6th, 2010, 10:43 PM posted to microsoft.public.access.reports
Bob Howard
external usenet poster
 
Posts: 71
Default Extra blank line on report

SOLVED! This is one "for the books"!

The group header (where grow and shrink are both set to "No" at the group
level) contains a text box where I sometimes insert a comment. The text box
was set to shrink ... but not to grow. This should not affect the
formatting of the header (since it can't grow or shrink).

When that text box contains a comment that FILLS THE BOX TO THE BOTTOM, then
the problem of the blank line occurs. But when the text box does not
contain anything, or its text does not fill it all the way to the bottom,
then that text box shrinks.

And somehow that caused the entire header section to grow! Perhaps this is
because I set the fontsize for that text box in the VBA code.

But this should not cause the SECTION to grow ... ever! It is set to
neither grow nor shrink.

It's fixed, but I would say this is an error in Access 2003.

bob

"Bob Howard" wrote in message
...
Access 2003...

I have a report with a group header and detail lines.

The group header has a fixed size, and set to neither grow nor shrink.
The bottom-most control in the group header is a horizontal line (to set
it apart from the details that follow).

The detail contains one row of controls, but one of these is set so it can
grow (in case the text doesn't fit on the single line). The detail
section itself is set to shrink, but NOT to grow. Some of the controls
have "Hide Duplicates" set to yes ... but I don't see what this has to do
with the problem.

Here's what happens: Between the group header and the first detail line,
I always get what appears to be a single blank line. This appears
immediately following the header's horizontal line and the first line of
the detail section. There's only one blank line ... not one before each
detail line.

And this occurs for EVERY group header (and its details) in the entire
report.

I've checked the sizes and other attributes of the controls, etc., and can
find nothing wrong!

Any clues??

bob



 




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 08:10 AM.


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