Adding ellipses to lengthy text

[phxbypdx]

Hey all -

I feel like this should be pretty easy.

I have a text field that allows 200 characters. I want to display this field on a form. If the text field has a length of longer than 20 characters, I want to truncate the display of the field, showing only the first 20 characters, plus ...

e.g.
"Lorem ipsum dolor sit amet, consectetur adipisicing elit"

would be truncated to:

"Lorem ipsum dolor si..."

How can I do this?

Thanks,

Scott

 

[pbaldy]

Presuming you don't want to be able to edit this, try a textbox with a control source of:

=IIf(Len(FieldName) > 20, Left(FieldName, 20) & "...", FieldName)