FileName Field Trimed to first 11 characters?

K

Kerri

Is there a way to take any field and "trim" it. I have a
FileName field that is too long. We are unable to change
the actual name of the file because it is accessing it
from a document management program. I only want the
first 11 characters of the field and nothing else.

Any suggestions. I realize this could require VBA, but I
hope not. Thank you in advance for your help!

Kerri
 
Top