Dispalay rtf data from linked Oracle table

[Paul]

Hi,

I'm working on some forms/reports that display (no need to write) data from
an Oracle database via linked tables (ODBC).

One of the Oracle fields contains data that I suspect is in Rich Text
Format. Many of the entries start with:

{\rtf1\ansi\ansicpg1252\...

Followed by text that contains other embedded rtf formatting codes.

The linked table shows the field as a memo field when the table design is
viewed in Access (though Access creates a bound object field when the field
is dragged from the field list onto a form or report).

Is there a simple way of displaying just the text without any of the rtf
encoding?

Many thanks

 

[Rob Oldfield]

Bleaugh. Oracle data types.... you have to love them.

I haven't had this particular issue, but have seen lots of data type things
using ODBC. One alternative (that might be worth looking at if nobody comes
up with anything better and also if you have an SQL server available) is to
link the Oracle DB into SQL. I've found that to be more stable (although
the majority of work that I've done related to this has been through .Net)

Take a look at this for some detail....

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_07s5.asp

 

[Jamie]

Paul,

I don't know about "simple", but have you considered using a RichText
control on your Access form? You would have to code the display of data
into the control, but it is not too onerous and may be a solution.