Reporting on SQL table with RTF values - display in plain text RRS feed

  • Question

  • Hello All,

    I am attempting to format a simple report with access from an SQL DB that is linked (through ODBC)

    The SQL table has a field of data type "Long Text"  and a text format of "Plain text". I cant change these unfortunately. a typical value of this field looks like this.

    {\rtf1\deff0{\fonttbl{\f0 Calibri;}{\f1 Tahoma;}{\f2 Arial;}}{\colortbl ;\red0\green0\blue255 ;}{\*\defchp \fs22}{\*\listoverridetable}{\stylesheet {\ql\fs22 Normal;}{\*\cs1\f1\fs18 Default Paragraph Font;}{\*\cs2\sbasedon1\f2\fs16 Line Number;}{\*\cs3\ul\fs22\cf1 Hyperlink;}{\*\ts4\tsrowd\fs22\ql\trautofit1\tscellpaddfl3\tscellpaddl108\tscellpaddfr3\tscellpaddr108\tsvertalt\cltxlrtb Normal Table;}{\*\ts5\tsrowd\sbasedon4\fs22\ql\trbrdrt\brdrs\brdrw10\trbrdrl\brdrs\brdrw10\trbrdrb\brdrs\brdrw10\trbrdrr\brdrs\brdrw10\trbrdrh\brdrs\brdrw10\trbrdrv\brdrs\brdrw10\tscellpaddfl3\tscellpaddl108\tscellpaddfr3\tscellpaddr108\tsvertalt\cltxlrtb Table Simple 1;}}\nouicompat\splytwnine\htmautsp\sectd\pard\plain\ql{\lang3081\langfe3081\f1\fs16\cf0 This is the actual text of the field}\f1\fs16\par}

    When I add this field to the  report (via a text box - formatted as Rich text) the text doesn't appear until I actually click text box (for each row). When clicked, it does appear correctly - without the fomatting, but as soon as the text box loses focus, the text disappears again. Running a print preview seems to freeze the access DB....very odd indeed

    MS access 2016

    Tuesday, May 28, 2019 5:41 AM

All replies

  • What program created this RTF?

    RTF is not a rigidly defined and supported specification, so Access may have problems with this particular version.

    -Tom. Microsoft Access MVP

    Tuesday, May 28, 2019 1:22 PM