How do i use VB script to change the length of a string in a serial number field Follow
Hi All,
Trying to change the length of my serial number field before printing out the label.
the value is coming from Excel via a user form the length from the Excel file is 9 char and we only need to use the fist 7 char from the left.
I'm assuming the left function will do it but can't figure out were to do this, or the correct syntax.
Any help is appreciated.
Regards
Trevor
2 comments
0

Pete Thane
Comment actions
You could use the Left VB command but as per your other post the Transforms>Truncation route would be simpler
I have now tried this and it works perfectly, thanks for your assistance.
regards
Trevor
Please sign in to leave a comment.