Names

[rob p]

Name fields, first and last each 40 positions. How do I remove spaces from
end of first name and attach to last name?
thanks.

 

[Marshall Barton]

Name fields, first and last each 40 positions. How do I remove spaces from
end of first name and attach to last name?

Use a single text box to display them both. The text box
expression would be something like:

=FirstName & " " & LastName

 

[Al Camp]

Rob,
If you store Bob in the FirstName field (length 40), Access only saves
Bob (not Bob and 37 spaces)
Use "concatenation" to put the Last/First name together in a calculated
text control field...
= [LastName] & ", " & [FirstName]
would yield
Smith, Bob