Re: how to truncate a field in vba?

[alicejwz]

Re: how to truncate a field in vba?

Hi,
is there a cast function in vba?

I need to truncate a field pass in from a function. Also what if this field has less than say 10 characters what would happen using truncate?

Thanks!

 

[ejstefl]

I thought the cast function was used to convert data types... I'm not sure what you are trying to truncate, but check out the RIGHT, LEFT, and MID commands. These will let you choose only part of a string.