Names

  • Thread starter Thread starter rob p
  • Start date Start date
R

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.
 
rob said:
Name fields, first and last each 40 positions. How do I remove spaces from
end of first name and attach to last name?
Click to expand...

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

=FirstName & " " & LastName
 
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
 
Back
Top