Unanswered: Text Field - Adding leading zeros based on size
I have a text field (ID) in tblList that contains data that can be different lengths. I need to be able to add the appropriate number of leading 0's to the numeric data so that when completed all of the data in that field will have the same length (7). This will than be used to link it to another table.
As an example, I may have 1234 and I need it to be 0001234 or I'll have 12345 and I need it to be 0012345 but never longer than 7 characters.
Now to mix it up a bit more, at times there may also be text data in the field that I need to skip over and not add any zeros.