"Trim" Name and Address-Access 2007

M

Marilyn Myers

I have created a report (letter) with a return address. What is the format
so the name and city,state,zip do not have all the spaces or should I create
a field such as Name (John Doe) as opposed two fields-one for first name and
one for last name?
 
D

Duane Hookom

I have never experienced a field value entered into Access that retains
trailing spaces. Trim is rarely if ever needed for removing spaces from the
right side of text.

Store names in multiple fields and use:
FullName: [Firstname] & " " & [Lastname]
or
NameFull: [Lastname] & ", " & [Firstname]

=[city] & ", " & [state] & " " & [zip]
 
Top