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
