Rich Text - Access DB > SQL

[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 (51.72 KiB) Viewed 1391 times

Stimulsoft Report Representation of same data field

Report.001.jpeg (298.12 KiB) Viewed 1391 times

[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.