Solved

Problem Printing Envelopes in Access 2007

Posted on 2010-09-07
3
436 Views
Last Modified: 2012-06-27
I am trying to print envelopes in Access 2007 using a report that has its page properties set to be the same size as  a #10 envelope.  This is working fine except for the fact that the fields are not lining up very well.  Because some names are much longer than others, and some addresses have an additional second line with a suite number for example, I can't seem to get everything formatted in such a way that it looks normal.


I would like to have the addresses look like this:


John Doe
123 Anywhere Street
Suite 100
Nashville, TN 12345



Instead it looks like:


John          Doe
123    Anywhere       Street
Suite   100
Nashville,       TN      12345


Any help would be appreciated.
0
Comment
Question by:apsonline
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 7

Accepted Solution

by:
shaydie earned 125 total points
ID: 33622754
Use unbound text boxes on your report and add multiple fields together into one text box something like this:
=[FirsName] & " " & [LastName]
=[AddressPart1] & " " & [AddressPart2]
=[City] & ", " & [State] & " " & [ZipCode]

set the control source something like that replacing the actual field names from your data.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 33623202
or you could merge the fields in the underlying query.

SELECT [FirstName] & " " & [LastName] as FullName,
             [AddressNumber] & " " & [StreetName] & " " & [StreetType] & chr$(10) & chr$(13) & [AddressPart2] as Address,
             [City] & ", " & [State] & "  " & [Zip] as CityStateZip
FROM yourTable

Using this method, you only need three controls (txtFullName, txtAddress, txtCityStateZip).  Set the CanGrow property of txtAddress to Yes.  Using chr$(10) & chr$(13) should provide for wrapping the second part of the address to a second line.
0
 

Author Closing Comment

by:apsonline
ID: 33626413
This worked great; thank you
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question