Getting error when using '

[Ruegen]

Why prevent it? If the data in table has the character, users should be able to type it as part of the value to be matched.

If a user types an apostrophie that now works i.e. paul's

however if they happen to type: paul's "

then I get a '3075' error.



So if I prevent them from using "

then I can't get the error (or I can use error trap).

I'm not sure any school names would have "" in their name anyway unless you can again explain how to still filter for those.

[June7]

Okay, so it's not the apostrophe, it's typing a quote mark at the end (or anywhere in the input) that is the issue. Can either use code to validate the input or error trap. Either way, fix the input to remove " and continue the search.

[Ruegen]

Okay, so it's not the apostrophe, it's typing a quote mark at the end (or anywhere in the input) that is the issue. Can either use code to validate the input or error trap. Either way, fix the input to remove " and continue the search.

so if I have it make it = a string

then validate the string

then remove the " if there is one and replace it with null/nothing/""

that should solve it...?

[June7]

Unless the user accidentally typed " (paul"s) when they should have typed ' (paul's), in which case the fixed input will not match data and record does not return. Therefore, one frustrated user.

On second thought, might be better to trap the error and inform user and tell them to try again with correct input.

[Ruegen]

Unless the user accidentally typed " (paul"s) when they should have typed ' (paul's), in which case the fixed input will not match data and record does not return. Therefore, one frustrated user.

On second thought, might be better to trap the error and inform user and tell them to try again with correct input.

Yes less frustrated users = less asking me to fix problems in whiny voice...

[June7]

None of which deals with data entry input of paul"s. But that is rarer than the reverse of ' when should be " because " requires shift key.

Also, entering paul's ' (multiple ') will generate error.

There is no such thing as 'fool proof'. Always a better fool.