Passing textbox value to string variable

[Pinacle]

I have the following code under textbox_Afterupdate event

Dim newstr As Integer
newstr = Left(Me.Req_.Text, 2)

The above code is reading the value (Me.Req_.Text , Ex:'1423S') from the
form....but when i debug it the value in 'newstr' is 0. Could someone please
help !

Thanks

 

[Beetle]

You're naming your variable as if it were a string, but you're
declaring it as an integer, then trying to pass a string value
to it.

Either declare the variable as a string, or if the variable
needs to be an integer, convert the value before you pass it;

CInt(Left(Me.Req, 2))

 

[Hans Up]

I have the following code under textbox_Afterupdate event

Dim newstr As Integer
newstr = Left(Me.Req_.Text, 2)

The above code is reading the value (Me.Req_.Text , Ex:'1423S') from the
form....but when i debug it the value in 'newstr' is 0. Could someone please
help !

Thanks

What is the data type of Left(Me.Req_.Text, 2)?

Debug.Print TypeName(Left(Me.Req_.Text, 2))

If "String", you could try:

newstr = CInt(Left(Me.Req_.Text, 2))

 

[Pinacle]

Thank you Beetle and Hans up !! i converted the string value into integer and
it worked perfect !!