How do I limit a numeric field

Hi Bubblers
How do I limit a numeric field to be exactly 9 digits
Thank you

The dB needs to be feed data via inputs

Set the input to integer and its character count to 9

Dear Cmarchan
Thanks for replying so quickly.

I have no choice “number of characters is 9”.

Sorry my bad

Consider making it a text and when you save it to the dB convert it to a number

Dear Cmarchan
Sorry, I didn’t explain myself well.

I need to be able to type in exactly 9 numbers, neither less nor more.

I know how to limit the number of characters, but not the minimum.

Yeap that us the idea. Check the expression that I suggested. It requires them to be 9. You can add other conditions as well.

This topic was automatically closed after 70 days. New replies are no longer allowed.