Professional-Looking Address Block for Reports

In this Microsoft Access tutorial, I'm going to show you how to create a professional-looking address block for your reports. Specifically, we'll focus on ensuring that fields such as city, state, and ZIP code are not spaced out, and that there are no blank lines when data is missing.

Susan from Redlands, California (A Gold Member) says: I'm using your Invoicing database and it works real well, however is there any way to make the address block look better? The fields like city, state, and ZIP code are spaced out, and I added an "Address2" line and if there's nothing in it, it leaves a blank line there. Any ideas?

Prerequisites

• Invoicing: https://599cd.com/Invoicing
• Concatenation: https://599cd.com/Concat
• Null Math: https://599cd.com/NullMath
• Can Grow, Shrink: https://599cd.com/CanGrow

Recommended Courses

• Order Entry System: https://599cd.com/ACX8

Address Block

Put all of this on the same line in a text box. I just separated it here for readability:

=((([FirstName]+" ") & [LastName])+Chr(13)+Chr(10)) &
([Address]+Chr(13)+Chr(10)) & 
([Address2]+Chr(13)+Chr(10)) & 
((([City]+" ") & ([State]+" ") & ([ZIP]+" "))+Chr(13)+Chr(10)) &
([Country])

Up Next...

Format this address block. Change color, bold, font size:

• Address Block Format: https://599cd.com/AddressBlockFormat

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, ms access address block for reports no blank lines, Suppress blank lines on a report, can grow, can shrink, Avoiding blank Address lines in reports, how to eliminate blank rows, Removing blank lines from report