Address layout

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi,
I use a print labels query to print mailing labels from a small
database. The problem I have is that the title,first name and last name have
no spaces between them and print as one continuous wors.The capitals show up
correctly its just that I loose the spaces between the names. I tried
editing the template but adding spaces there does not work. What do I need
to do to have the title/names show correctly.Its more of an irritation than
a real problem. Tia, John
 
If you have 3 separate Fields then you simply combine then with added spaces
in a Query like:

FullName: [TitleField] & " " & [FNField] & " " & [LNField]

Select other Fields from your Table into the Query as required. Save the
Query and use the Query as the RecordSource for the Label Report.
 
Back
Top