string offset

[zhuanyi]

Hello,
Say I have a dynamically generated string (e.g., "Wah! What a big fish!") that I want keep all but the last character(i.e. changes to "Wah! What a big fish"), may I know how can I do that in VBA?

Thanks!

Anyi

 

[zhuanyi]

Never mind, I found it:
http://office.microsoft.com/en-us/access/HA010547271033.aspx