"Trim" Name and Address-Access 2007

  • Thread starter Thread starter Marilyn Myers
  • Start date Start date
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?
 
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]
 
Back
Top