This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 38%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Is there a workaround to get the HTML-ish RFT from ColumnHistory() of a LongText field set with RichText format and AppendOnly versioning?
I'm not trying to defend AppendOnly vs better solutions. Or storing HTML-ish RTF in Access. Just asking if anybody knows a way to get the RTF versions. I've only been able to get the plain text versions using ColumnHistory() even though rs!myLongTextField.Value returns the HTML-ish RTF as expected.
Attachment and MultiValue fields provide usable ways to get the (quirk-ish, not DBMS Good Housekeeping Seal of Approval, internally FK), data with Set rsvals = rs!MVField.value and Set rsattachments = rs!AttachmentField.Value. If the AppendOnly versions have a similar method--even if undocumented--I haven't found it. (I did try Set rsvers = rs!RTF_Ver_LongText.Value but it didn't work.)
Thanks in advance for any thoughts on how to accomplish this!
I posted a comment with a OneDrive link to a test case db. That comment seems to have been disappeared.
I don't have the answer handy but maybe check if the column history info is stored in a hidden table just like MVFs and Attachments are. If so, perhaps you can get the RTF from there. Just a thought...
Hi,
check if the column history info is stored in a hidden table
Yes, Colin describes it in this article. However, he doesn't mention if the HTML tags are stored too.
Servus
Karl
Access Forever, News, DevCon
Access-Entwickler-Konferenz AEK
Okay, seeing the article again (thanks, Karl), I remember it now. If you can send me a sample db with RTF column history, I could try to see if I can pull them. Colin's sample in his article seems to be using plain text (or at least that's what it looks like), so I can't tell from that if the RTF tags are available or not.
Somehow I didn't notice your post here.
https://1drv.ms/u/c/184F18B72D9DA949/EZ_zBtcq6_5DtMhapEAAZOIBDabZNrfeUaDgnUG439_jPg?e=HVcbGd has a sample .ACCDB (if it will let me) with one table and several bits of VBA. The file was basically a quick trial developing code to break back Attachment, HyperLink, and LongText (RTF and Append Only) fields to provide tools to undo uses of these Access "avoid these" constructs.
See rows ID 7 and 8 of the table, field Comment_RTF, and the sub walkLongTextAppendOnly and its sub ParseVerHistToDict which breaks down ColumnHistory() of the field values that include, in the case of row ID=8, several versions of RTF AppendOnly data.