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

Multi font in one field

P: n/a
Is it possible to place multiple fonts into one field of an access report?
What I need to do is place some text which is in a specific font (used by
nurseries to show of a unique species of plant) with an existing plant name
which has a font already selected.

I thought of combining two fields with different fonts but when they were
combined it reverts back to one font.

Can anyone help? Is this possible to do?

Cheers in Advance - Scott
Jul 6 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
You can do this in Access 2007, which supports rich text. (It's HTML
actually.)

In earlier versions, you would need to load a rich text control such as this
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.

"scott" <sc**********@maneyacts.comwrote in message
news:46***********************@per-qv1-newsreader-01.iinet.net.au...
Is it possible to place multiple fonts into one field of an access report?
What I need to do is place some text which is in a specific font (used by
nurseries to show of a unique species of plant) with an existing plant
name which has a font already selected.

I thought of combining two fields with different fonts but when they were
combined it reverts back to one font.
Jul 6 '07 #2

P: n/a
Allan - Thank you. This is a perfect solution. I have taken a look at the
link and it's very usefull. In addition to what you've already answered, is
it possible in the field where the OCX looks to combine two other fields?

The two fields would be "Plant" and "UniqueID" found in a form
"frmPlantList" What we need to do is have the one OCX fiels show the two
fields combined, lets say "Plant1 Unique" with Plant 1 being in Bold Ariel
and Plant 1 in Italic Ariel.

I wanted to know if in this scenario you could have in the OCX control
source something like
[forms]![frmPlantList]![Plant],[forms]![frmPlantList]![UniqueID]
and it would see the two fields to give the predefined font formating.

Thanks again. Your advice is alway appreciated!

"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:46***********************@per-qv1-newsreader-01.iinet.net.au...
You can do this in Access 2007, which supports rich text. (It's HTML
actually.)

In earlier versions, you would need to load a rich text control such as
this
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.

"scott" <sc**********@maneyacts.comwrote in message
news:46***********************@per-qv1-newsreader-01.iinet.net.au...
>Is it possible to place multiple fonts into one field of an access
report?
What I need to do is place some text which is in a specific font (used by
nurseries to show of a unique species of plant) with an existing plant
name which has a font already selected.

I thought of combining two fields with different fonts but when they were
combined it reverts back to one font.

Jul 7 '07 #3

P: n/a
Hi Scott.

While I have not tested it, I can't see any reason why you could not
programmatically write the Rich Text Format data yourself (either by
concatenating 2 existing memos that contain RTF, or by adding RTF tags
yourself when you concatenate them), and then display it in the Rich Text
control.

Again, be aware that Access 2007 uses HTML, not RTF, for what it calls "rich
text." Therefore if you go with the RTF solution, you may not be heading in
the right direction for the long-term future.

--
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.

"scott" <sc**********@maneyacts.comwrote in message
news:46***********************@per-qv1-newsreader-01.iinet.net.au...
Allan - Thank you. This is a perfect solution. I have taken a look at the
link and it's very usefull. In addition to what you've already answered,
is
it possible in the field where the OCX looks to combine two other fields?

The two fields would be "Plant" and "UniqueID" found in a form
"frmPlantList" What we need to do is have the one OCX fiels show the two
fields combined, lets say "Plant1 Unique" with Plant 1 being in Bold Ariel
and Plant 1 in Italic Ariel.

I wanted to know if in this scenario you could have in the OCX control
source something like
[forms]![frmPlantList]![Plant],[forms]![frmPlantList]![UniqueID]
and it would see the two fields to give the predefined font formating.

Thanks again. Your advice is alway appreciated!

"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:46***********************@per-qv1-newsreader-01.iinet.net.au...
>You can do this in Access 2007, which supports rich text. (It's HTML
actually.)

In earlier versions, you would need to load a rich text control such as
this
one:
http://www.lebans.com/richtext.htm

"scott" <sc**********@maneyacts.comwrote in message
news:46***********************@per-qv1-newsreader-01.iinet.net.au...
>>Is it possible to place multiple fonts into one field of an access
report?
What I need to do is place some text which is in a specific font (used
by
nurseries to show of a unique species of plant) with an existing plant
name which has a font already selected.

I thought of combining two fields with different fonts but when they
were
combined it reverts back to one font.
Jul 7 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.