replace the single quote with one more quote i thnk that shld help
or with char(146)

Regards,
Deepak Londhe



>From: "Avinash" <avinashraj@h...>
>Reply-To: "professional vb" <pro_vb@p...>
>To: "professional vb" <pro_vb@p...>
>Subject: [pro_vb] Re: Crystal Reports - Selection Formula
>Date: Tue, 11 Dec 2001 10:44:00
>
>Hi Deepak,
>
>Thanks, but my problem is when strFieldValue itself has a single quote in
>it, Crystal Reports starts trowing an error.
>
>strFieldValue = "test's"
>rpt.SelectionFormaula = "{TableName.FieldName} = '" & strFieldValue & "'"
>
>thanks,
>Avinash
>
>
>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp