Integer to string conversion

[divined]

Hello everybody

What`s the easiest way to convert an Integer to a String. I was thinking of creating a variant variable and using it like shown below :

Dim int1 As Variant
Dim strText As String

int1 = 2
strText = "Some text..." & int1.

But this does not work. It crashes with a type validation error. Can such code work or do I need to use some integerTostring conversion function?

thx, in advance

George Papadopoulos

[Deepak Sakpal]

Dim int1 As Variant
Dim strText As String
 
strText = CStr(int1)

[DeadEyes]

Lose the Variant if it's an integer declare it as such.

[Bombdrop]

if you are are converting a Variant type to a string the use the

Cstr$ method that Deepak Sakpal shows but if you know that its a numeric you can use the str$() function.

Point of note if you miss the trailing $ from a function it will not convert to a string but to a varaiant and then VB will make the conversion from variant to sting for you thus is less effienct so always use the $ there are a few functions to use the $

mid$
left$
Right$
ucase$
LCase$

Just remeber if you want to return a string from a built-in function alwasy place $ at the end.

Hope this helped!!!!

[brucevde]

Dim int1 As Variant
Dim strText As String

int1 = 2
strText = "Some text..." & int1

This code will not produce an error. Are you using .NET?

[techgnome]

Well, if divined is using .NET, then Variant would throw an error right off the bat as it doesn't exist in .NET.

I'm going to guess that the code sample is a simplified representation of the real problem and that it isn't the actual code. Moreover, the variable is probably getting set to some value other than a numerical 2 and it's that value that is causing the error. Prime example why variants should be outlawed.

TG

PS: Bombdrop - CStr$ doesn't exist as a function in VB. Since by it's very nature, CStr returns a string, if you put $ on the end of it VB takes it right off.