Type Mismatch on a variable

[HebieBug]

My understanding of a variable that is set to variant means that it can accept both charaters and numeric.
Tried something this morning:

Dim test as variant
Dim caption as variant
test = 0
caption = " " + test + " " + me.Text1

Up comes the error type mis match the problem is with the Test variable being placed within the caption
Have tried changing te caption to a sting ect...
Anyone mind going back to basis or me

 

[dpaulson]

Your problem is not with the variable dimmed as a variant, but the fact that you are ADDING (+) a string to a number when in fact you want to concatenate(&). But I beleive that a variant can either hold a string or a numeric, but not both at the same time. What I mean is that if a number is concatenate to a string, then the number is converted to a string first and this variant will hold only a string value.

David Paulson

 

[JohnYingling]

Give up variants unless they are required. They are not being supported in VB.Net except as a compatibility (read sloooow) object.

http://WWW.VBCompare.Com

 

[mukund]

Hi,
Try this out. Instead of using the + signe, use the & for concatenation.

caption = " " & test & " " & me.Text1


Mukund.