Rich Text in Access 2007

[PC User]

I've worked with the editing commands for the rich text activex in
Access 2000; however, Access 2007 now has text fields where the
property can be changed from plain text to rich text. The rich text
editing commands for the rich text activex do not work for the rich
text property for a A2K7 textbox. I know there are alternate rich
text programming and activex that can be purchased, but my question is
solely for the rich text property that Microsoft provides in Access
2007. Has anyone found the rich text editing commands for this?

Thanks,
PC

 

[Allen Browne]

The "rich text" in Access 2007 is actually HTML, not RTF as used in previous
versions. That's why the editing tools (and the data) is not compatible.

If you need a true RTF control, Stephen Lebans has one:
http://www.lebans.com/richtext.htm

You can programmatically manipulate the HTML in A2007 if it helps, e.g.:
This word is <b>bold</b>, and this is <i>italics</i>.

 

[PC User]

Thank you Allen,

I know there are alternate rich text programming and
activex that can be purchased, but my question is solely for the rich
text property that Microsoft provides in Access 2007.

PC

 

[Allen Browne]

Stephen's RTF is free (not for 'purchase'.)

Since the examples I provided of how to programmatically edit the HTML did
not satisify you, I guess I did not understand what you meant by asking:
Has anyone found the rich text editing commands for this?

 

[PC User]

Our company used to use MS Office 2000, but now we have MS Office
2007. Our IT Security has programmed our network and the Vista system
on our pc, not to accept anything added by the user. I do not have
administrative rights to my work pc. We are strictly prohibited from
using any add-ons or alternate activex things. I had this same
problem when I tried developing a module with richtext function and a
form to edit richtext. Now all that work can not function on Access
2007 with the duel properties of textboxes using only HTML. I found
an HTML editor in A2K that doesn't work well with A2K7 in that it uses
an Internet Explorer activex and I am frustrated in linking the text
back to the richtextbox. Many times the Internet Explorer activex has
trouble finding its library DLL in the System32 folder.

Essentially I'm back to square one with the richtext issue as I was
about 5 years ago. Microsoft has no help on the HTML richtext. Your
suggestion on editing HTML appears like its manually editing the text
content directly instead of having a more user friendly way of
selecting the text and pushing a format button as in a richtext
editor.

So you see, the strict security protocols on my work pc prevents me
from using Stephen Leban's true RTF control or any other non-Microsoft
add-in or activex because in order for these to work they have to be
registered in the Windows registry. Strict security protocols
prevent altering the Windows registry. My question is that I'm
looking for editing commands to put into code that will format the
HTML richtext that is used in A2K7. Are you saying that Stephen
Leban's richtext activex uses HTML?

Thanks for your reply,
PC

 

[Allen Browne]

Okay, I think you understand that RTF and HTML are worlds apart.

If you have developed your own form for editing RTF and storing the results
in a memo field in Access 2000, the simplest approach would be to continue
using that in Access 2007. If you create new tables in Access 2007, set them
to plain text, and they will behave just the same as in previous versions,
i.e. you can still store RTF in a memo, and use your form to edit it.

Stephen Lebans' control is for RTF, so won't be of any use if you already
have your own form for doing RTF editing.

 

[PC User]

I cannot use the previous rtf editor for 2 reasons:

1. When opeining a existing form with and existing rtf activex, I get
an error: "There is no object in this control."
2. When I try to insert a new occurance of an rtf activex, I get an
error: "Microsoft Office Access doesn't support this ActiveX
control."

Are the rtf activex editing commands compatable with HTML, because
A2K7 won't allow the use of an rtf activex control?


Thanks,
PC

 

[Allen Browne]

Are the rtf activex editing commands compatable with HTML

No. HTML editing and RTF editing are worlds apart.