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

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Merge Ltr in Access 2
How to add a return in a text box if second field has data 7
empty field 2
Extra lines being inserted in Access report 1
v look up formula to generate a blank line 1
How to eliminate blank line 5

Top