Blank lines in a report

S

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
 
T

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
 
S

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
Click to expand...


Thanks all.
 

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

Joining VLookups with line breaks but ignoring blanks 3
Remove Null fields in a report in address 2
Populating textbox with more than one row of text 2
Populating Address fields in form 3
Merging text fields 1
blank lines in merge document 3
Printing Addresses 2
Concatenate part of two textboxes and then save the result 5

Top