Form prints Boxes instead of apostrophes

[kv444]

Hi,

The crystal report form is printing boxes instead of apostrophes,but the format stored in the database is the correct one but for some reason the form cannot print the same. for example holiday's is stored as holidays.Could some one please help suggest me how i can fix this.


Thanks for your help in advance.

 

[lbass]

Try changing the font--I'm guessing this is the issue.

-LB

 

[kv444]

Hi Thanks for your reply.The font i'm using is Arial 10 and this is the standard font i am supposed to use for this report.I tried changing the font but still see the error.Is there any other way you suggest i can try perhaps write a formula for this.Can you please let me know.

Appreciate your help.Thanks!



Holidays

 

[lbass]

Try this:

stringvar x := "Holidays";
replace(x,mid(x,8,1),"'");

It looks like your current apostrophe is being misinterpreted.

-LB

 

[kv444]

Hi,i tried this but i guess i explained it wrong earlier.

This is a block of text that needs to be displayed in the report and there are words inside the text file with apostrophes that are being displayed as a box instead of the apostrophe symbol.

sorry for the error.is there some thing i can do to fix this.could you please let me know


Thanks a lot for your help !

 

[lbass]

stringvar x := {table.text};
replace(x,"","'");

-LB

 

[lbass]

Googling this clarifies that the issue is with character encoding in older software (Word) versions, and I'm wondering whether you can take care of this in Word, before accessing it in CR.

-LB