MeaganMcOlin
4 years agoQrew Cadet
How to shorten the display of a text field?
I have a comments field that is long enough to really mess up the table view, so I want it to only display the first 20 words unless you click into it. How can I do that?
I tried to do use this formula to shorten the view of my "appt. comments" text field in my table.
Left([Appt. Comments],20)
However, I received this message "Formula error
A formula may not contain a reference to itself directly or indirectly through another formula."
Any idea on how to do this?
------------------------------
Meagan McOlin
------------------------------