Comments field growing too large for reports and form tables.

Can you post an example of your comments field?  Is it a  text field set to "Log Changes" with new comments at the bottom?

Hi - thank you for the reply and sorry for delay getting back.  Out sick yesterday.

Yes, I have it set to log changes, and have most current comments at the top (I deselected option for having them at the bottom).

OK, try this crazy looking formula
substitute your field name into the first line where my field name for testing was 
[Log changes append only at the top]


var text LogField = [Log changes append only at the top];

If(Trim($logField)<>"", 
"[" & Left(NotLeft($LogField,"["),"["))

Is this formula for the target Comments field? ("Current Comments").  I am trying to grab the most recent comment (which is appearing at the top of the long running "Comments" field), and display it as the current comment in a different Comments Field ("Current Comments"). 

In the "Current Comments" field, I only want to display the last comment made from the other Comments field. I plan to include this current comments field in reporting, tables, etc.

Does that make sense?

Did you try my formula? 
Yes, it is the formula for the formula text field called [Current Comments]

Oh, ok.  I didn't see reference to the other Comments field in the formula.  thats what threw me off.

You are the man!!  It works!!   Thank you very much for the help!!