Report Display (2003 SP1)

Topic

New Reply

Is it possible to only display the first 100 characters in a report field. I have a field named comments in my report, but I’d rather it display the first 100 characters with a “…” after the last 100 if there is more text.

Reply | Quote

Replies

Create a text box with control source

=IIf(Len([Comments])>100,Left([Comments],100) & “…”,[Comments])

The name of the text box should be different from Comments to avoid confusion; you can use txtComments for example.

Reply | Quote