Rich Text formatting in Access 2007

[Robert McN]

In Access 2007, is it possible to add rich text formatting to text in a memo
field (or mixed formatting within any text field). I have just upgraded to
the new version of Access, and it appears that this feature still has not
been added. Is this correct? (If so, why?) If it is not possible to format
individual words within a field in Access, , is there a simple, free add-in
that will enable Access to do this kind of basic formatting, such as adding
italic, bold, and underlining?

Thanks very much for any information you may have.
Bob

 

[Tom Ventouris]

Rich Text format for Memos in:
Tables - Look in the Properties General Tab, third from the bottom.
Forms and Reports - Proprties Data Tab, second from the top.

Be sure to set the Text Format to Rich Text in the table as well as the form
or report, or you get all sorts of symbols where the formatting should be.

 

[UpRider]

Robert, rich text is valid for Memo type fields. You have to set text type
to rich text in table design view, then set it again for the control holding
the memo field in form design.

UpRider

 

[Robert McN]

It is rare that a new software feature can bring joy to my heart, but I am
practically ecstatic. I have been asking for this feature, literally, for
about 13 years. I figured it would never come. Thanks for pointing this
out. And thank you to the developers who made this change. You've made my
day.

Question: do you know if one exports data say to MS Word, will the Rich Text
formatting be retained?

Bob

 

[Robert McN]

Thank you very much for getting back to me. This is excellent news.

Bob

 

[Tom Ventouris]

Yes, better than we've come to expect in earler versions. Having said this,
it is based on my experience with export to Word 2007.

 

[ma50blue]

I am new to this thread........I have Access 2003 and sent an earlier
question about copying in excerpts from various WORD documents into a memo
field on my form. The WORD formatting does weird things in Access. One
person answered and said it was how it handled "rich text formatting". Do
you know of any way to handle this in Access 2003. I guess in Access 2007 it
is no longer a problem. Is this problem totally resolved in 2007 or could I
still have issues. I need to pull in language from 33 different labor
contracts and there is all kinds of various WORD formatting involved. I
wonder if the upgrade would be worth it.

Thanks for any advice

 

[PJMayo]

Just a warning about the Rich Text setting. I have run into three issues so
far. I have not determined all the idiocracies but in case you start pulling
hair:
1. Form and report Text Boxes whose content is controlled by a calculated
field from a Query may not let you to select Rich Text for display. It
appears to work with small queries but becomes troublesome with larger
queries. My current workaround is to put the calculation directly in the
Text Box control.
2. Report Text Boxes will not shrink when empty. They will even grow to
text height if originally smaller. Not sure what is causing this but the
same Text Box, same content, formatted as Plain Text works perfectly. This
one has me pulling hair.
3. A memo field's content may get stored surrounded by <DIV></DIV> tags
which, when concatenated with something else, introduces an unexpected line
break. I had to make a homemade function to parse out <DIV></DIV> tags.

I also love that Microsoft finally supports Rich Text but Microsoft did a
half-assed job of implementing it.

Phil.