envelopes

[Beth B]

Hello,

I am trying to do envelopes in ACCESS. I have created a query that has a
criteria feild so I can just pull up specific records. I have the design of
the envelope working perfectly except for one thing. I have two address
fields and sometimes the second one is blank. I need it so that if the
second field is empty that everything moves up so that there is not a blank
space.

Thanks,

Beth

 

[Arvin Meyer [MVP]]

Use the Trim function to clear any spaces that may occur like this:

=Trim([SecondAddress])

Now select the text box and set the CanShrink property to Yes (True) in the
Format section of the preoperty sheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Beth B]

This worked perfectly. Thank you so much. This was my first time trying
these discussion groups. it is so helpful.

Use the Trim function to clear any spaces that may occur like this:

=Trim([SecondAddress])

Now select the text box and set the CanShrink property to Yes (True) in the
Format section of the preoperty sheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hello,

I am trying to do envelopes in ACCESS. I have created a query that has a
criteria feild so I can just pull up specific records. I have the design of
the envelope working perfectly except for one thing. I have two address
fields and sometimes the second one is blank. I need it so that if the
second field is empty that everything moves up so that there is not a blank
space.

Thanks,

Beth

 

[Beth B]

I tried doing this in the form letter portion and it did not move anything
around. I still have the space in the middle of the address

Use the Trim function to clear any spaces that may occur like this:

=Trim([SecondAddress])

Now select the text box and set the CanShrink property to Yes (True) in the
Format section of the preoperty sheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hello,

I am trying to do envelopes in ACCESS. I have created a query that has a
criteria feild so I can just pull up specific records. I have the design of
the envelope working perfectly except for one thing. I have two address
fields and sometimes the second one is blank. I need it so that if the
second field is empty that everything moves up so that there is not a blank
space.

Thanks,

Beth

 

[John Vinson]

I tried doing this in the form letter portion and it did not move anything
around. I still have the space in the middle of the address

Try setting the CanGrow and CanShrink properties of the Report
textboxes to True; they'll shrink away to nothing if there is no data.

John W. Vinson[MVP]

 

[Arvin Meyer [MVP]]

You may have something else on the same line. In that case you can only
shrink if the other object is also empty. In a letter, look for a date or a
logo on the opposite side. If you can move it up (or down), you'll probably
solve your problem.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I tried doing this in the form letter portion and it did not move anything
around. I still have the space in the middle of the address

Use the Trim function to clear any spaces that may occur like this:

=Trim([SecondAddress])

Now select the text box and set the CanShrink property to Yes (True) in the
Format section of the preoperty sheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hello,

I am trying to do envelopes in ACCESS. I have created a query that has a
criteria feild so I can just pull up specific records. I have the

design
of

the envelope working perfectly except for one thing. I have two address
fields and sometimes the second one is blank. I need it so that if the
second field is empty that everything moves up so that there is not a blank
space.

Thanks,

Beth