Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / January 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MaGr - 14 Apr 2006 16:21 GMT
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?
KARL DEWEY - 14 Apr 2006 16:51 GMT
Set the Can Shrink  and Can Grow property to Yes and then reduce the size of
the text box to a narrow line.

> 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?
Al Camp - 14 Apr 2006 17:52 GMT
  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.
Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

> 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?
Christine - 29 Jan 2008 02:42 GMT
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

> 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.