InfoPath Dev

How do I enable a user from entering in just Numeric characters in a text box? Please help.

Michael

Hi Michael,

If you want only numeric values in text box then you need to add a validation for that field like
1. “fieldname” is less than are equal to -65,536 or
2. “fieldname” is less than are equal to 65,535

Otherwise on validation condition you can select ‘use formula#%92 in right side drop down and set your condition depends on your requirement then it will shows the validation.

I did not see the type of Validation for only numeric when I looked is it a certain formula

One Question. How do I get Info Path to retrieve data from the SQL database and display it back to the infopath form when a user opens the form. Also, what is the query to SUM up the monthly totals to one grand total.

Thanks