Limiting the number of characters displayed

[Mozz]

Hello,

I'm trying to limit the number of text characters displayed in various fields on a form. I want it to appear so that after a certain number of characters it then displayed "..." indicating there is now information in a field.

Thanks for any help!

 

[Sergeant]

Something like this:

Left([MyField],InStr([B][COLOR="Red"]20[/COLOR][/B],[MyField]," ")-1) & "..."

Change the '20' to the character position where you want to start looking for a break-point (space).

The sentence above this one would become:
Change the '20' to the...