How do i use VB script to change the length of a string in a serial number field Follow

0
Avatar
trevor callaghan

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
Avatar
Pete Thane
Comment actions Permalink

You could use the Left VB command but as per your other post the Transforms>Truncation route would be simpler

0
Avatar
trevor callaghan
Comment actions Permalink

I have now tried this and it works perfectly, thanks for your assistance.

 

regards

Trevor

Please sign in to leave a comment.