Crystal + dealing with '

[mike55]

Am after stumbling on a major error in my code when dealing with crystal reports, I found that if a name has an appostraphy, then crystal throws the following error:

Error in File C:\DOCUME~1\D2400\ASPNET\LOCALS~1\Temp\temp_dc5b0c65-f99b-49dd-8890-6219bd883c85.rpt: Error in formula <User>. ''Michael O'Donnell'' The remaining text does not appear to be part of the formula. 

 

When I pass values to crystal, I am using FormulaFields. So is there a way to get Crystal to accept the appostraphy or do I have to remove it or replace it with a different character?

 

Mike55.

[penfold69]

Try quoting the ' with \

 

i.e.:

 

'Michael O\'Donnel'

[mike55]

Try quoting the ' with \

 

i.e.:

 

'Michael O\'Donnel'

 

No luck, crystal is still spotting the ' and throwing a fit. It seems that I will have to settle with replacing the ' with the ` character.

Thanks for your suggest though.

 

Mike55

Edited June 9, 2005 by mike55