Rich Text Formatting of Data by the User

[Sedrick]

In the past I have seen an Active-X addition that allows the user to do Rich Text formatting in MS Access Text or Memo Fields, similar to an MS Word Document with highlighting, bolding, underlining, etc. This was created by Mr. Laban I believe.

My question is two-fold.

1. Do the newer versions of MS Access allow the user to do rich text formatting of the data they enter in Text or Memo fields?

2. Has anyone done development of a package that would be easy to implement and would allow the user to actually use an MS Word document so that it could be formatted as desired (even allowing bullets if desired and everything else that MS Word allows) and still store the data in MS Access rather than (or in a addition to) an MS Word document so that it could be searched, filtered, etc with standard MS Access tools?

I'm thinking that it would be good if a form or report could be used with this feature so that the user could both enter and see the data on a report with his or her formatting, while the text data itself in a query or table would not need to appear with the formatting.

I have worked in the past in a limited way with Excel data entry and MS Word formatted documents from MS Access but it would be nice if this process has been streamlined for easy setup for data entry that allowed it.

Has anyone actually done anything in this area yet?

Thanks!

[zmbd]

Starting in ACC2007:

----------

[Insert or add a rich text field]

In Microsoft Office Access 2007, you can store rich, formatted text in a database. You do this by using a memo field and setting the field's TextFormat property (new in Office Access 2007) to RichText. You can apply formatting to all or part of the contents of the field by editing the field through a bound control in a form, or when the field is displayed in a datasheet. You can also apply formatting to all of a field when viewing a report in Layout View (new in Office Access 2007).

----------

As for the remainder of your question, you can use Office-Automation a short article about this Application Automation this covers Outlook and Excel; however, Word will work too. It is somewhat of a pain to do - but possible
-z

[Sedrick]

Thanks! Will need to take a closer look. Funny, when I searched for this on the web it came up with nothing about Access 2007. Thanks again.

[zmbd]

it's a Chemist's touch with the search engines (^_^)