Okay, I may be getting in over my head here, but I’m going to give it a try.
Let’s say that I create a table, and that one of the columns is set up as a Memo field. If the text that is stored in the field is a block of HTML code, is there a way that I can generate a report which displays the contents as it would be read by a browser?
I don’t think you can make Access generate an pure text report stripped of all formatting.
Instead, you’d have to write some custom code to transfer the memo field contents to a file. Similar to example shown here: http://www.eggheadcafe.com/software/aspnet/35504157/how-to-write-text-file.aspx
Disclaimer: I don’t have 2007, still in 2003, so I’m just tossing out some possible avenues to pursue.
Does the report have to be in Access?
Because Word can produce HTML documents, and it will read Access data. So you might be able to do a merge file with the Memo fields.
I know A2003 has Data Access Pages, although I’ve never used them. My understanding is that they’re basically html reports. Does 2007 have something similar that you could use?
I don’t want to strip out the coding. I want the database to use the HTML in the cell to format the text correctly.
So if the cell contains this text:
The report shows this:
For the record, I’ve tried setting up the cell to contain RTF data, but that method isn’t working well in preserving paragraph formats.
And yes, it does need to be in a database. These blocks of HTML will be cross-linked to data from numerous tables.
Somewhere amongst the huge list of activex objects you can add to your forms and reports, there should be one that renders HTML - I thought it was called IEcontrol or some such, but I can’t find it.
It should be like a textbox to use, but capable of rendering HTML
That would be the Microsoft Web Browser Active X control.
I know it will do the job for displaying HTML if you add it to a form, but I don’t know if it will print HTML in a report. It’s worth a try though…