Remove character returns

[LuckyMe]

Hi,

By using Trim function to remove space of a Text. But how can I remove the character return(S). The reason I asked is because sometimes the user hit character return to move the cursor to the other field instead of using Tab, and they leave the character return in the fields. It seems there is a simple solution for this, but I could not figure out.

Thank you

[SteveB]

Substitute(string,"P","") where 'P' the that backwards character that is the CR.

[LuckyMe]

Thank you very much for a very quick reply. It works.