Is there anyway to allow an apostrophe (') when entering text to a db? <BR><BR>Thanks,<BR>Allan
yes. double them up<BR><BR>there are functions to do this in the codelibrary at http://www.infinitemonkeys.ws/infinitemonkeys/<BR><BR>j
But what if it is a user entered field?
Before writing into the database use this function:<BR>function ReplaceApo(aVal)<BR> Dim s <BR> ReplaceApo = replace(aVal,"'",chr(34))<BR>end function<BR>