Access Envelope Report Formatting

[Guest]

I am setting up a report to print an envelope. I have a form where I selects
a record from a combo box and views information the information on the form.
I have built a query based on the current record displayed and am trying to
create a report based on that query. Everything works great except I need to
format the report so that it will adjust if a field is blank. I have a name
line and three address lines followed by a line for city state and
zip(example 1). There are times when the second and third address lines are
needed, but not always. Is it possible to have the report adjust so that if
the second and third address lines are blank everything else moves up so
there is not a gap?

(example 1)
Name
Address line 1
Address line 2
Address line 3
City, St, Zip

 

[fredg]

I am setting up a report to print an envelope. I have a form where I selects
a record from a combo box and views information the information on the form.
I have built a query based on the current record displayed and am trying to
create a report based on that query. Everything works great except I need to
format the report so that it will adjust if a field is blank. I have a name
line and three address lines followed by a line for city state and
zip(example 1). There are times when the second and third address lines are
needed, but not always. Is it possible to have the report adjust so that if
the second and third address lines are blank everything else moves up so
there is not a gap?

(example 1)
Name
Address line 1
Address line 2
Address line 3
City, St, Zip

Set each of the 3 address lines CanShrink property to Yes.
As long as there is no other control on that same line, text will move
up.

 

[Guest]

Thank you! That was so easy I am a little embarrassed. Thanks for the quick
responce.