Checking to see if text field values equal 100 2

[josephwc]

I have a series of text fields in an MS Access XP form.
They represent number values as shown below. I do not want to convert these values into numbers but on the form I want to make sure that the text field values entered if they were numbered equals 100. Any ideas?

Field1 = "000"
Field2 = "050"
Field3 = "050

 

[Remou]

Val("50") will convert to a number for your purpose.

 

[TheAceMan1]

or

[blue]CInt("050")[/blue]

See Ya! . . . . . .