RTF2 Control - Property is read only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave G - 10 Jan 2005 18:22 GMT

I am attempting to use this control in an unbound contect, loading its value
from a table based upon user input. i.e.:

Set rst = New ADODB.Recordset
With rst
.ActiveConnection = CurrentProject.Connection
.CursorType = adOpenDynamic
.Open "SELECT * FROM tbl" & SourceTable & " WHERE [UPC] = '" &
gstrUPC & "'"
.MoveFirst
txt171.rtfText = !Details
end with

The text does load, but first generates the error message "Property is read
only".

Any suggestions

Reply to this Message

Stephen Lebans - 10 Jan 2005 18:43 GMT

ActiveX controls( and even bound Access controls) are not fully
instantiated during the Form's Open event. Just move your code into the
Form's Load event.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> I am attempting to use this control in an unbound contect, loading its value
> from a table based upon user input. i.e.:
[quoted text clipped - 13 lines]
>
> Any suggestions

Reply to this Message

piotr morgulo - 22 Feb 2005 17:27 GMT

I've this same problem, but I use this control on a report (onFormat event)
. This worked fine on Access 2000 but now I convert database to 2003 and
I've got this error.
If I open report in preview mode everything is OK, the error is raised only
when I print the report...

Reply to this Message

Toby Cundell - 16 Mar 2005 06:25 GMT

I have the same problem also in Access 2003. I used the example database
from your site by Andre Minhorst to split apart long text into the series
of paragrphs.

This works great in preview mode but throws a Property is Read-Only error
for every instance of the control on the page when you try to print the
report. I tried trapping this error through all the normal ways I know how
and I havent found a way to keep it from throwing the error. The report
DOES print correctly however. But it is unacceptable for the client to
click OK 25 times to print a report.

The example database has the same problem when you try to print the
paragraphs version.

Thank you very much in advance for any help!!!

Reply to this Message