Trim spaces in address fields

[Guest]

I have fields for LName & Fname and would like to "trim" (maybe the wrong
term) the extra spaces from the fields so that when I have the two on a form
side by side it appears as John Doe not John Doe

 

[Rick B]

this is posted all the time. Please read previous posts before posting a
new thread.

You would need to add an unbound text box to your form or report and put the
data as...

=[Fname] & " " & [LName]

Obviously the user will not be able to modify the data in that field. It is
simply for display purposes.

 

[Lynn Trapp]

LTrim(RTrim([FName])) & " " & LTrim(RTrim([LName]))

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Guest]

Thanks Rick. Sorry to bother you. I've been searching and didn't see what I
needed

this is posted all the time. Please read previous posts before posting a
new thread.

You would need to add an unbound text box to your form or report and put the
data as...

=[Fname] & " " & [LName]

Obviously the user will not be able to modify the data in that field. It is
simply for display purposes.

--
Rick B

I have fields for LName & Fname and would like to "trim" (maybe the wrong
term) the extra spaces from the fields so that when I have the two on a form
side by side it appears as John Doe not John Doe

 

[Douglas J. Steele]

Or, simpler,

Trim(([FName]) & " " & Trim([LName])

(You been spending too much time with Oracle again, Lynn? <g>)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

LTrim(RTrim([FName])) & " " & LTrim(RTrim([LName]))

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

I have fields for LName & Fname and would like to "trim" (maybe the wrong
term) the extra spaces from the fields so that when I have the two on a
form
side by side it appears as John Doe not John Doe

 

[Lynn Trapp]

Well, it do pay my salary. <g>

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Larry Daugherty]

Trim() is exactly the right function for removing leading and trailing
spaces. Space characters are not the problem. It's the fact that you
have to design textboxes with finite dimensions and peg their spacing
on the form.

The usual work-around is to replace the FName and LName textboxes with
an unbound textbox say "txtFullName" and set the value of txtFullName
=[FName] & " " & [LName]

A word of caution: Don't get rid of the fields in the table for FName
and LName. There is a value in having them separate; such as sorting
by last name.

HTH