In AC2007 I have some memo fields, which are pulled through a query from a AC2003 database.
AC2007 have built in support for Rich Text functionality, and I need to use this because I have created some Compare Version code, that compares a memo field to an older version of the same memo field, and highlights changes.
In order for the formatting to appear properly, I set the field in the table and the field in the report to RichText. However, the data inside the fields are still plaintext. Now I can run a HTMLEncode() function on the data, but I notice that if I open the same table in a form, make it dirty, that access encodes the memo field in a different way then the HTMLEncode function does (and slighly prettier)
Does anyone know which function access uses to encode plaintext->Rich Text, and if its accessible to developers?