Re: Frustrated with data entry people

Better option, forget trapping paste and instead, use the changeValue event to look for and remove illegal characters - then, no matter how they got there, you remove them.

I prefer this over doing it at export because then your database has good data, not just your export.

Liz


Jim Hargan wrote:
On Thu, 28 Jun 2007 10:15:37 -0700, Ike wrote:

2. Write OPAL code that intercepts the ctrl-v, and instead of doing the
default paste event, substitutes your own custom method. This method would
paste the text into a string variable and then, perhaps, step through it
looking for illegal characters. If you only want to scrub CR/LF, a
breakApart will do it in a single whack. Personally, I step through the
entire string and expunge *all* low and high ascii, including tabs (each of
which gets replaced with three spaces).


Jim Hargan
.