if no data in field, how to reduce space on report

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a report that has multiple fields one of which is a
comments field. The problem that I am having is that for
most of the records, the comments field is blank. Only
about 10% of the records have comments.

When I print the report, the size of the report is very
large because the comments field (even if blank) takes up
a constant amount of space for each record. What I would
like is for the space between records (i.e the comment
field) to be dynamic based on whether there is any data in
the comments field or not.

Is there an easy way to do this?

Thnaks,

Dave
 
1. make the text box the height of a normal text box
2. set the control source to "=IIf([Comments]="" Or
Isnull([Comments]),Null,[Comments])
3. then set the CanGrow and CanShrink Property of the text box to Yes

Hope it helps!
-David
 
Thanks...worked like a charm. I did also have to set the
detail record property to CanShrink in addition to the
text box to get it to work.

Thanks again,

Dave

-----Original Message-----
1. make the text box the height of a normal text box
2. set the control source to "=IIf([Comments]="" Or
Isnull([Comments]),Null,[Comments])
3. then set the CanGrow and CanShrink Property of the text box to Yes

Hope it helps!
-David

Dave said:
I have a report that has multiple fields one of which is a
comments field. The problem that I am having is that for
most of the records, the comments field is blank. Only
about 10% of the records have comments.

When I print the report, the size of the report is very
large because the comments field (even if blank) takes up
a constant amount of space for each record. What I would
like is for the space between records (i.e the comment
field) to be dynamic based on whether there is any data in
the comments field or not.

Is there an easy way to do this?

Thnaks,

Dave
Click to expand...


.
Click to expand...
 
Back
Top