Search results

Thanks for the quick response! I used this on the report field and it did work perfectly. =Replace([InstantMessage],"'","'")

Does anyone know how to remove the ' from data stored in a table? For example, I have the following text stored in a table: "I didn't see that coming." Is there a way to clean that data up so that it says: "I didn't see that coming."? Thanks in advance!

I would need to do it by pulling it in a record set because the data reside in a live table that I am connecting to via an ODBC connection. They XML is not in a txt file. The table name is [IMSG_Conversation] and the Memo field that contains the XML data is called [data]. See attached image of...

I am trying to pull Text from a table that is storing the data in XML format. The code you guys explain here looks like it might give me some direction but I'm not sure how to use the code you explained here? I don't use Modules or Macros in MS Access. I tried creating the Module but when I run...

Where in the module code do you declare the table / field that you want to extract the data from?