Access 2007 supports Rich Text displays for memo fields. When I convert the data to SQL Server tables, the embedded HTML tags goes with it. However, since the field is no longer a "memo" type field, Access shows all the tags instead of interpreting the tags to show the data in Rich Text format. Is there any way to work around this?
I just had a thought... is there a way to Dim a temporary field as Memo in VBA? If so, then I could copy the SQL Server varchar field into it and display/print the temporary field. Thoughts?
Well, I guess this is just a non-problem. When you specify a text format of Rich Text, it displays/prints it as if it were native to Access 2007.
Thanks, Eddie