By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,775 Members | 1,432 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,775 IT Pros & Developers. It's quick & easy.

Names and addresses in report

P: n/a
I am trying to set up a report that looks like a letter, so like
Contactaddress1
Contactaddress2
Contactaddress3
Contactaddress4
Postcode

This works fine but looks messy if, say, there is no Contactaddress4.
Is there some way that if a box is blank, there is no space left, as
when mailmerging using Word.

Thanks

Janet

Aug 11 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Set the CanShink property of each text box to Yes.

Provided there is nothing else overlapping the text boxes vertically, they
will shrink.

The CanShink property of the (Detail?) section will be set to yes as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"janet" <jd********@btinternet.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...
>I am trying to set up a report that looks like a letter, so like
Contactaddress1
Contactaddress2
Contactaddress3
Contactaddress4
Postcode

This works fine but looks messy if, say, there is no Contactaddress4.
Is there some way that if a box is blank, there is no space left, as
when mailmerging using Word.

Thanks

Janet

Aug 11 '06 #2

P: n/a
Many thanks - I had tried the CanShrink, but I think the boxes must
have been overlapping slightly - its now looking a lot better.

Have a good weekend

Janet
Allen Browne wrote:
Set the CanShink property of each text box to Yes.

Provided there is nothing else overlapping the text boxes vertically, they
will shrink.

The CanShink property of the (Detail?) section will be set to yes as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"janet" <jd********@btinternet.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...
I am trying to set up a report that looks like a letter, so like
Contactaddress1
Contactaddress2
Contactaddress3
Contactaddress4
Postcode

This works fine but looks messy if, say, there is no Contactaddress4.
Is there some way that if a box is blank, there is no space left, as
when mailmerging using Word.

Thanks

Janet
Aug 11 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.