Formatting Memo Field Text

[Ian]

Dear All,

Does anyone know if it is possible to format memo field text. I have a form
field (a Textbox) that uses a tables memo field as it's source. I would like
to be able to make some of the text in that memo field Bold and even change
its colour. If this is not possible (using Access 2002) does anyone know how
to use a formatted text file (? a Word doc) in place of the memo field.

Thanks for your ideas,
Ian.

 

[Rick Brandt]

Dear All,

Does anyone know if it is possible to format memo field text. I have
a form field (a Textbox) that uses a tables memo field as it's
source. I would like to be able to make some of the text in that memo
field Bold and even change its colour. If this is not possible (using
Access 2002) does anyone know how to use a formatted text file (? a
Word doc) in place of the memo field.

Thanks for your ideas,
Ian.

Access 2007 supports this with a "Rich Text" property (which actually uses
HTML). In older version you woudl have to use a third party control for
Rich Text (and those use actual RTF).

Note that use of either of these impacts the behavior of your database
because you are no longer storing the same text that you see on the screen.
If you want your field to be searchable that matters quite a bit.

 

[Douglas J. Steele]

On the surface, it's not possible: the text box control in Access doesn't
have that capability. However, you can use an RTF control. Stephen Lebans
has a free one at http://www.lebans.com/richtext.htm

It's not as straightforward as using a text box, though: I don't believe you
can bind the control to the field in the form's underlying recordset (but
then you can't do that using a Word document either, and that would be far
more work)

 

[Pedro]

é

 

[Ian]

Thanks to you both, it looks like the RTF route is the way to go and although
I'm having a little difficulty installing the RTF2 files from lebans.com,
I'll figure it out.

Cheers,
Ian.