Trim a string in VBA
Hello!
Could anyone provide me with the line of code to trim a string of text?
I have a field that I need to use to value of in my code, but I need to trim the first 3 characters off. For example: The value for field [9-CCNNumber] in a record is "07-43", but I need VBA to only pick up the "43".
Any help is greatly appreciated!
Regards,
Laura
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
__________________
Regards,
Laura
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
|