Serial Number confusion.
I am generating specific 13 digit numbers which are made up from a range of individually entered codes (both text and numeric). I then combine these individual elements to create a single number, which i can then validate as unique. This all works fine.
The problem i am having is with how the Serial number field is displayed in the entry field.
I need the auto-generated serial number to be in the range 000 to 999 - and that when the serial and other codes are combined, the result shows correctly (example - ABC/SCDG003/020 ) Yet in the entry field for the Serial it only shows the 3...I need to display all three digits in the serial, including the leading zero's.
Any idea how i can achieve this?