Hi,
I think I've seen this come up before. I have many fields where the
person who entered data has consistently hit the 'enter' key causing
a carriage return in those fields. How can I do a script to remove
those carriage returns.
It causes a real problem when those fields are used in drop down
list, as it will not display data from the fields where this has
occurred.
--
Lee
Do a calculated replace:
Replace Field with Substitue (Field; Carriage Return; "")
That should do it even if they hit the enter key a couple of times.
HTH
Dave McQueen
