I have a data field that you input a name of a web site. For example "Ram's Horn" - now that Apostrophe in that name is not accepted. Is it possible to make it accept this apostrophe?
Use Replace function which is available in VBscript
hi david<BR><BR>just to expand on the last post:<BR><BR>strText = Replace(strText, "'", "''")<BR><BR>ie: replace one apostrophe with two (may be best to view code in monospaced font like courier)<BR><BR>cheers,<BR><BR>neil