Length of numeric entries in a form

I have a form that asks for the Sq Inches of Material Picked and the Sq Inches of Material Used. If the Sq In Used entry is greater than the Sq In Picked entry, a Msg Box appears stating the Sq In Used Must Be Less Than The Sq In Picked. This works fine if the length of both numbers (ie Number of digits) is the same. For example, 99 & 82 or 250 & 128 or 1200 & 1180. But I get an error if the length of the numbers are different (eg. 100 & 82 or 1200 & 999). The code is:

Please Login or Register  to view this content.

Hi sbernard

The values in the user form are text. Try changing this line of code and see if it helps

Please Login or Register  to view this content.

John