Text Box Limits ?? 1

[holdenvn]

I have got two text boxes on a form where users punch in measurements. When txtmulldist1 is less than txtmulldist2 it brings up a message, which works fine. The error im getting is when txtmulldist1 is greater than 9999 the operation doesn't work. Here is some of the code

If txtMullDist1 < txtMullDist2 Then
MsgBox &quot;...&quot;
End If

i was just wondering if there is any limitaions with the text box or am i missing something. If any one could help me it would be greatly appreciated.

 

[bridamol]

Try this one

If cdbl(txtMullDist1.Text) < cdbl(txtMullDist2.Text) Then
MsgBox &quot;...&quot;
End If

 

[holdenvn]

thanks bridamol worked well