Join 2 Fields...Results Not What I Expect

[dieselrocks]

When I join 2 fields together, I'd expect to get just the values without spaces. However, when I join the first and last name fields I get:

James Jones

instead of

JamesJones

Any idea????

[dieselrocks]

I get James.......Jon es......

instead of

JamesJones


the dots represent spaces in the first example

[ajalwaysus]

Best reason I can think of right of the top of my head is that you either have a space at the end of "James " or you have a space at the beginning of " Jones".

If this is the issue, you can put your field names in "Trim"
i.e.

 Trim([First_Name]) & Trim([Last_Name])

If this is not the issue, please post your code, as there is now way of figuring this out beyond this without it.

-AJ

[dieselrocks]

AJ,

The trim function worked....Thank s!!