Skip to Content
Former Member
Apr 10, 2009 at 06:13 PM

Carriage Return in total field


I want to put a carriage return in the total/sum field. I am doing this so the report will show the column sum and underneath it a percent. I am doing this is the format editor - Display String with this code:

ToText(ToText(currentfieldvalue) + chr(13) + totext(Int((TC123/currentfieldvalue)*100),"##") + "%")

From what I read the chr(13) should work, but it doesn't.

Any suggestions on how this can be accomplished?