Blank lines in a report

[Sparky]

In Word mail merge from an Access dB there is an option not to print
blank lines. Can something similar be done on an Access report to
prevent line gaps in an envelope address

eg

address1
address2
address3
postcode

However iff address 3 is blank...

address1
address2
postcode

Tks

Sparky

 

[tina]

in report design view, try this: set the section's CanGrow and CanShrink
properties to Yes. and set the Address3 control's CanGrow and CanShrink
properties to Yes.

hth

 

[Sparky]

In Word mail merge from an Access dB there is an option not to print
blank lines. Can something similar be done on an Access report to
prevent line gaps in an envelope address

eg

address1
address2
address3
postcode

However iff address 3 is blank...

address1
address2
postcode

Tks

Sparky

Thanks all.