By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,146 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Formatting in memo fields

P: n/a
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
Dec 15 '07 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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
Dec 15 '07 #2

P: n/a
Ah, very many thanks
Dec 16 '07 #3

P: n/a
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?
Dec 17 '07 #4

P: n/a
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?
Dec 17 '07 #5

P: n/a
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
Dec 17 '07 #6

P: n/a

"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
Dec 17 '07 #7

P: n/a
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
Dec 18 '07 #8

This discussion thread is closed

Replies have been disabled for this discussion.