Concatenation Question About Removing Spaces

[FontanaS]

Hi,

I have the following field in my report that concatenates the user's last name, then puts a comma, and then the user's first name -

=[monitor] & "," & [text50]

Problem is the results look like -

fontana , Sandra

how do i get the spaces out of there?
i can't make the field sizes shorter.

THANKS!

 

[willir]

Use TRIM to remove leading and trailing spaces. LTRIM and RTRIM remove spaces to the left and right.

Syntax is easy...

=TRIM([monitor]) & ", " & TRIM([text50])

Note that I inlcuded a space after your comma.

Teh "gotcha" is if your variable is Null.

So perhaps a better alternative would be to use the NZ function...

=TRIM(NZ([monitor])) & ", " & TRIM(NZ([text50]))


Richard

 

[PaulBricker]

=Trim([monitor]) & ", " & Trim([text50])

That should do it.

Paul