Numeric Field Format
Posted on 2001-07-23
Hello all. I have a form in a shared database that I have a question on formatting.
First of all, is there any way to get a message box or some type of warning to appear after tabbing off the field if text has been placed in the field. Currently the warning only pops up upon clicking the send button.
Also, can you set the length of the field to a certain amount (ie: 10 characters), and can you have the field insert zeros in front of what the user inputs to the field lenth. Example: If user inputs 12345, the field automatically fills in five zeros in front to make the number 0000012345.
Eventually we would like to do some sort of "scrape" from one of our systems that has numbers in this format so this would help a lot.