I am using R5.
I have a subform that displays the history of changes made to the form that it is included in. The various fields contain multiple values each seperated by a CR. I would like a formula to use in a column in a view that will cause the last value in a field. For example, the column will display the "Date last Modified" or "Last Changes Made". I suppose I could write an hidden field which contains the last entry only, but I wondered if it was possible using a formula.