Page 1 of 1

Rich Text - Access DB > SQL

Posted: Fri Mar 11, 2016 1:53 pm
by russr999
Hi,

Currently I have a microsoft access database as a front end for an application and SQL server as the back end.
The ms access front end has certain fields set as "rich text" and these save back to the SQL database with the RTF formatting included.

When I try to use these fields in Stimulsoft reports I get mixed results:
  • Text Box - Allow HTML Tags: these nearly shows the text as intended but does need show it exactly as it is entered in the textbox in access (eg: blank lines do not show)
  • Rich Text Box - Theere seems to be no way to show the RTF from access in this box
Please help - I need to be able to show the data as enterted as RTF in access the same way in a stimulsoft report.

MS Access RTF input box - Screenshot
accessscreenshot.jpg
accessscreenshot.jpg (51.72 KiB) Viewed 1393 times
Stimulsoft Report Representation of same data field
Report.001.jpeg
Report.001.jpeg (298.12 KiB) Viewed 1393 times

Re: Rich Text - Access DB > SQL

Posted: Mon Mar 14, 2016 6:16 am
by HighAley
Hello.

It seems that in your database the text with HTML but not the Rich Text.
Due to restrictions of the .Net Framework we support limited set of HTML tags.
You could read more about all supported tags in the User Manual.

Please, try to set the Can Grow property of the text component to true.

Thank you.