Removing Control Characters from Text Boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharkbyte - 20 Jul 2007 15:24 GMT

I have an issue where the users are cutting/pasting text, from emails, and
Access is returning an error that the field is too small to accept the data
they are attempting to 'add'.

The text is obviously not too long, so I am assuming that there are unwanted
control characters, coming over in the paste process.

Could someone offer some suggested code that will remove any unnecessary
control characters? I'm guessing it will probably use the Replace command,
but I have no idea about syntax.

Thanks, in advance.

Sharkbyte

Reply to this Message

pietlinden@hotmail.com - 21 Jul 2007 06:52 GMT

> I have an issue where the users are cutting/pasting text, from emails, and
> Access is returning an error that the field is too small to accept the data
[quoted text clipped - 10 lines]
>
> Sharkbyte

you could
1. create a new function that receives a string and returns a string
2. create an array of the characters you want to get rid of inside the
function
3. loop through the array, running Replace on your input string until
you get to the end of the array of characters.
4. return the finished string

Reply to this Message