How to shrink/expand fields in a report.

[PaulChilds]

Hi,

I have a report which prints off an envelope using the following fields from a query:

[Name]
[Address 1]
[Address 2]
[Town]
[County]
[Postcode]

Each field has it's own text box, but this can cause problems when, for example, a person does not have an entry in [Address 2], as it leaves a gap on the envelope.

Any ideas on how to fix this?

CHeers.

P and K

http://www.worship-leader.co.uk

http://www.liverpooldream.co.uk

http://www.ormskirkparish.co.uk

http://www.cadetsltd.co.uk

 

[PaulBricker]

Have you looked at the can shrink/can grow properties for your report. You set these properties to Yes for each textbox in the Report. That should solve your problem.

Paul