How do I avoid blank lines in addresses on Access Reports?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On an Access report, how can I handle an "In care of" line on an address
without leaving a blank line on the records without a c/o?
 
Set the Can Shrink and Can Grow property to Yes and then reduce the size of
the text box to a narrow line.
 
Dewey's solution is the easiest, but I prefer to have a bit more control over the text
spacing between lines.
Can Grow expands the text control height according to the font, and can yield an
address with too much space between lines. Particulary in labels.

I set the fields up for the following field values... (aircode)
FullName
Addr1
If IsNull Addr2 then City State Zip here... Else Addr2
If IsNull Addr2 then Null here... Else City State Zip
This way I can control the height of the text controls, and even overlap the lines to
get a "tighter" appearing address.
 
I gave up on trying to format letters properly in Access. I just tried the
following and found it works best for my purposes. Instead of an Access
report, I create a merge document in Word and use the records from the table
or query in Access. It's very easy to do. Open a blank form in Word, click on
Tools, Letters and Mailings, Mail Merge, and the directions pop up in a
column on the right side of the screen. You just have remember to close the
Access table or query that you're drawing records from. Using this method,
I'm able to edit letters individually, as well. This is very helpful when I
have a common letter going out to a large group and just want to edit an
occasional letter. This may not be the best choice for everyone but it works
for me so thought I'd just share.
Christine
 
Back
Top