Formatting in memo fields

[anthony]

Is there any way that individual words or phrases can be formatted
within a memo field? Obviously, the whole field can have formatting
applied but I'm interested in being able to format just part of the
field. This will be in a report

Many thanks

[Allen Browne]

You can do this in Access 2007, by setting the Text Format property of the
memo field in your table to Rich Text.

In earlier versions, you cannot do this with the standard text box. If it is
important, you could install a special control to show the rich text. Here's
one:
http://www.lebans.com/richtext.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"anthony" <an*************@gmail.comwrote in message
news:4d**********************************@r29g2000 hsg.googlegroups.com...

Is there any way that individual words or phrases can be formatted
within a memo field? Obviously, the whole field can have formatting
applied but I'm interested in being able to format just part of the
field. This will be in a report

Many thanks

[anthony]

Ah, very many thanks

[anthony]

Before I look further into this, could give me an idea as to how it
works? Does it effectively mirror what the rich text property in
Access 2007 does ie give me the abilty to enter text into a memo
field, with individual words or phrases formatted as required, which
itself is held in the back end tables database and then have that pre-
formatted data reproduced via the front end report? Does the control
need to be attached to both databases?

[Allen Browne]

In a Rich Text memo field, Access stores the text and formatting in the
table.

In a calculated control, the expression is stored in the Control Source
property of the text box. So, you could have just:
="Have a <b>good</dday!"
In that expression, nothing is stored in the fields of the table.

Alternatively, the expression in the text box could combine literals (like
the above) and data from a field. The previous example showed 2 fields plus
the formatting in the literals.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"anthony" <an*************@gmail.comwrote in message
news:f8**********************************@l32g2000 hse.googlegroups.com...

Before I look further into this, could give me an idea as to how it
works? Does it effectively mirror what the rich text property in
Access 2007 does ie give me the abilty to enter text into a memo
field, with individual words or phrases formatted as required, which
itself is held in the back end tables database and then have that pre-
formatted data reproduced via the front end report? Does the control
need to be attached to both databases?

[anthony]

I think I understand what you are saying - the nub of it being that if
I want to enter variably formatted text directly into a memo field in
a back end table, I need to do it in Access 2007

[Larry Linson]

"anthony" <an*************@gmail.comwrote

I think I understand what you are saying - the nub
of it being that if I want to enter variably formatted
text directly into a memo field in a back end table,
I need to do it in Access 2007

There is a Rich Text Box control that comes or used to come with the
Developer Edition, FMS has a third party Rich Text control, and MVP Stephen
Lebans has, if I remember correctly, a free one at his site
http://www.lebans.com. As all of those predate the implementation in Access
2007, compatibility between them and Access 2007 would not be assured. The
Rich Text Box Control and the FMS product are .OCX ActiveX Controls, and I
think Stephens' is, too, so you would have to distribute the .OCX DLL along
with your application if you are distributing it to others.

Larry Linson
Microsoft Access MVP

[Allen Browne]

No, the text box in A2007 has a new property that can display a sub-set of
HTML tags as rich text. The text box in previous versions could not do that.

As Larry says, you can get an add-in to use in previous versions. However,
my recollection is the Stephen Lebans' control (and most of the others) use
RTF (Rich Text Format) to store the formatting, not HTML tags like A2007
does. So an A2007 text box would not display the formatted text correctly,
unless you use the ActiveX control in the new version also.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"anthony" <an*************@gmail.comwrote in message
news:1e**********************************@i3g2000h sf.googlegroups.com...

>I think I understand what you are saying - the nub of it being that if
I want to enter variably formatted text directly into a memo field in
a back end table, I need to do it in Access 2007