Is this a bug in Access

[GraeagleBill]

Dim strTestString As String
Dim I As Integer

I = 1

strTestString = "HdText" & Str(I)

strTestString = "HdText" & Trim(Str(I))

The first setting of strTestString results in "HdText 1" while the second results with the desired string "HdText1". What's with the leading blank returned from the "Str" function?

[pbaldy]

From help on Str():

When numbers are converted to strings, a leading space is always reserved for the sign of number. If number is positive, the returned string contains a leading space and the plus sign is implied.

[GraeagleBill]

Thanks. Funny all the times I've used the Str function it hasn't been with a string concatenation.

[pbaldy]

No problem. I'd typically just do:

strTestString = "HdText" & I

[GraeagleBill]

Now that you mention what you do typically I'm reminded that that is what I've done in the past myself. The current app development is peppered with string data so I had my "string" hat on when I coded the concatenation the first time and then spent 20 minutes chasing the resulting bug in Debug where the unwanted "blank" was inserted.