In one of the reports I made, I am trying to print out a field that was imported from an email. Unfortunately, the field has little boxes in it at the beginning of each carriage return. The boxes are those kind that mean unrecognizable character, and when I print, each line prints on top of each other, as if there was a carriage return, but no linefeed. If I manually go in and delete the boxes, I can print fine. Is there any function that will allow me to remove all of these boxes from my field?

Field contents look like this:

Dear John,

"box"This message was sent to you

"box"regarding....

"box" etc.

and the last 3 lines will all be overlapping.

Hope this is clear. Thanks for the help.

If you can copy and paste the "box" symbol, you could use the Substitute function, replace the "box" with a space or paragraph character.

e.g., Substitute ("EmailBodyText";"box";" ")

I tried that, but it doesn't work. I think the box is a character that represents a whole host of things, so it doesn't substitute in correctly. Anything else?

Thanks.