I am selecting fields from a database and displaying them on a form. When the field contains an apostrophe in it the data is truncated to the end of the field. For example if the field <BR>contains the words "Lee's Summit", it is displayed on the form as only "Lee". I have tried using the following code to correct the problem but the results are the same.<BR> apos = CHR(39)<BR> tempcity = Replace(tempcity,"'",apos)<BR>I am able to do inserts into the database ok even if they contain<BR>apostrophes. It is only displaying them that causes problems.<BR>Thanks for any help you can provide.