>Is there an obvious way to remove trailing carriage returns at the end of memo field - nasty in reports that display alltrimed memos. I have tried a substr() command replacing chr(13) with "" but this not working. Thank you in advance if someone knows the best way.
To add to the 2 suggestions you already have...
I encountered a problem similar to this, one of my users had managed to insert 1000's of CR's on the end of a memo field
They went to lunch with a book resting on the keyboard
But at the end of the CR's they had carried on typing into the memo field and then hit save.
This took me ages to find.. (stretch to fit over 15 pages) I thought the report was corrupted etc.
I suppose what I'm getting round to is that maybe you should look through the entire memo field not just at the end.
Will
Will Jones