Hi quick question as I'm having trouble finding an answer.
I have a text field where the USER enters a number, which needs to automatically format the data to TEN digits.
ie.. if the user enters 71 in the field then it will change to 0000000071
ie.. if the user enters 1296 in the field then it will change to 0000001296
or any other combination.
It links to a ODBC Data Source and hence needs ten digits in text to work.