Stuart McLachlan
stuart at lexacorp.com.pg
Thu May 8 19:46:13 CDT 2003
On 8 May 2003 at 17:19, Jim Lawrence (AccessD) wrote:
>
> I have used this same technique many times in the past, but this time it
> just won't work.
>
> It has to be the single quotes inside the Err_Description.
>
If you are trying to insert a single quote in a field in an SQL statement you need to "Escape" it by making it two
consecutive single quotes.
Try Replace("ErrDescription",Chr$(39),CHr$(39) & Chr$(39)) instead of just ErrDescription
--
Stuart McLachlan
Lexacorp Ltd
Application Development, IT Consultancy
http://www.lexacorp.com.pg