Paul,

>Is there anyway to do an alltrim with a memo field? I've tried it but it doesn't seem to make a difference. I'm open to any other suggestions. For those who do, Thanks!

The effect you're seeing is the fact that ALLTRIM() trims only spaces, not carriage returns and line feeds ( CHR(13)+CHR(10) ). What you likely have is a memo field that has a bunch of extra blank lines after the end of the text, and that is waht is causing the blank space and the extra page. The cause is generally users who from habit use the Enter key to progress to the next field, and should be using Tab. They hit Enter a bunch of times trying to leave the editbox, and you have 'mysterious' blank lines or extra pages in a report.

Here's a solution that was offered to me about 3 years ago:
Re: Extra space on Memolines Thread #675123 Message #675142

Enjoy!