Pesky Memo Field

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
 
F

Fredg

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.
 
D

Don Rountree

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.





.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top