F
FirstVette52
I have an ID number text field that uses the format 'L00000000'. My table
already has some 3000+ entries 2-7 characters in length (ie: 27340) that need
to be padded to 9 characters (ie: L00027340), the first character 'L' and the
rest '0's.
I used the following Input Mask !/L00000000 and the 'L' appears, but the
zeroes do not, just spaces.
I appreciate any help you may be able to provide.
already has some 3000+ entries 2-7 characters in length (ie: 27340) that need
to be padded to 9 characters (ie: L00027340), the first character 'L' and the
rest '0's.
I used the following Input Mask !/L00000000 and the 'L' appears, but the
zeroes do not, just spaces.
I appreciate any help you may be able to provide.