set a field to accept only numbers

[Meg]

Is there a way in Infopath to set a field to accept only numbers?

My DB is in Access and I have that field set up as a number field.

I am using InfoPath 2007, however this application (form) was created in
2003 ver.

Thanks,

MEG

 

[Swathi (GGK Tech)]

Hi,

You can change the data type to Whole number (integer) as Shiva said. If you
don’t want to change the data type then add a data validation to accept only
numbers. For this add the following expression in the data validation.
not(xdUtil:Match(string(.), "\d*"))

 

[Meg]

Thanks, this worked.

MEG

Hello,

You have to add the field data type is integer then automatically if you
enters other than integer value it will gives error message. If you want to
restrict only enters positive numbers then add the validation.