change type mismatch error

[msasan1367]

Hi
I have two textbox and I want enter only numbers on them
validation rule for first texbox is >0
validation rule for second texbox is >5
when I enter a letter on first or second textbox, it shows 'type mismatch' error


how to change this error?
thanks



dba.zip

[June7]

You can set the Format property to General Number and will get a different message: The value you entered isn't valid for this field.

Otherwise, will have to use code (VBA or macro) to validate entry.

[msasan1367]

but when textbox attach to table, I can't change format property. what should I do?
dba-edit.mdb

[June7]

You want to enter numbers into textboxes but the fields are set as text type. What is the nature of this number data - what does it represent?

[msasan1367]

thanks, I convert it to number and my problem is solved