Pesky Memo Field

  • Thread starter Thread starter Don Rountree
  • Start date Start date
D

Don Rountree

I am printing a report that contains a memo field. Not
every record has a memo associated with it; however, when
the report prints, there is a blank line where the memo
would be if one was available. Is there a way to
eliminate the memo field, or the space it takes up, when a
record does not have a memo? If there is, where would the
code go? Thanks...

Don Rountree
 
Don,
Set the Memo field's Can Shrink property to Yes.
Set the Detail Section's Can Shrink property to Yes.

There must not be another control on the same line.

An alternative is to make the height of the Memo field very small and the
height of the detail to just under the last row of controls.
Then set the CanGrow properties of both the field and the Detail section to
Yes.
 
How simple. Thanks...

-----Original Message-----
Don,
Set the Memo field's Can Shrink property to Yes.
Set the Detail Section's Can Shrink property to Yes.

There must not be another control on the same line.

An alternative is to make the height of the Memo field very small and the
height of the detail to just under the last row of controls.
Then set the CanGrow properties of both the field and the Detail section to
Yes.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.





.
Click to expand...
 
Back
Top