Reports and empty lines

[ericb]

How do I manage to not leave an empty line if the field is empty.

For example I have :
Name
Address
Apartment
City
Province

Now if the Apartment filed is empty I do not want an empty line. I want the
City line at it's place or to move up.

How do I do that ?

Thank you

 

[KARL DEWEY]

Set the Can Shrink property to Yes.

 

[Jeff Boyce]

There's empty, and then there's "empty". Access recognizes a zero-length
string, a null, and a space (or 100 spaces) as different.

Humans, on the other hand, can't readily tell the difference.

If you are guaranteed that there's nothing in there (i.e., a Null), Karl's
approach will handle it.

If you are uncertain, you'll need to test for them and convert to Null to
get Karl's approach to work. You can do that test/convert in your query
underlying the report.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[ericb]

I changed that setting and nothing happens.

I'm using Access2007, does it change anything ?

I put the fields in the page header and detail, to see, and it is the same
thing. The empty line is still there.

Have another idea ?

Thank you