MS Access Rpt how do you close up a line when the field is empty

T

tcrank

In an Access report ...
I want to close up the 2nd line in the report for my [Address 2] field when
it is blank so there is no space left between
Line 1 ... [Address 1]
and
Line 3 ... [City, St Zip Code]

How do I accomplish that?
Thanks!
 
R

Rob Parker

Set the Can Shrink property of the textbox containing [Address 2] to Yes.
Also set the Can Shrink property of the report section containing the
controls to Yes.

This will only work if there are no other controls occupying the same
vertical space in that section of the report.

HTH,

Rob
 

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

Similar Threads

Merge Ltr in Access 2
How to add a return in a text box if second field has data 7
empty field 2
Access Envelope Report Formatting 2
How to eliminate blank line 5
Extra lines being inserted in Access report 1
How do I suppress blank lines in reports 1
How to Suppress Report Line Containing Label But With Blank/Null D 2

Top