Replace one character with another while entering in forms
Hi,
I have an application where I collect
Title & author Names. ( both single line text field)
Sometimes, the title contains an apostrophe...say.. " Sam's sham", ( its ok where i collect this info)
Then Later when i use this field as a picklist in another form,
The field having the apostrophe comes as blank in the view
I belive this could be due to the fact that apostrophe is read as single quote and the text gets commented out.
So, would it be possible to replace the apostrophe with an underscore in the mainform itself
Sam's sham == Sam_s sham
( something in the lines of replace keycode...)
Thanks in advance for your time and effort.
Regards,