Not displaying blank fields in a record

[Guest]

I have a report and contained in it is two fieds. Persnlnme1 and Persnlnme2.
Persnlnme1 only always contains short text whereas Persnlnme2 is a memo field
and can contain lots of text though it might also be blank.

What is happening is that the memo field takes a lot of room on the page and
maybe an entire page is mostly blank because of the field size on the page.

Is it possible to have the field displayed only on records where the field
(Personlnme2) contains data and display it if there is data? and still show
all other information for each record? Thank you.

 

[Marshall Barton]

I have a report and contained in it is two fieds. Persnlnme1 and Persnlnme2.
Persnlnme1 only always contains short text whereas Persnlnme2 is a memo field
and can contain lots of text though it might also be blank.

What is happening is that the memo field takes a lot of room on the page and
maybe an entire page is mostly blank because of the field size on the page.

Is it possible to have the field displayed only on records where the field
(Personlnme2) contains data and display it if there is data? and still show
all other information for each record? Thank you.

Not sure what your problem is here, but I think it might
help if you make that memo field's text box short and set
it's CanGrow property to Yes. Then you can drag the detail
section's bottom up to the bottom of the other controls.