apply bold to part of concatenated string

[Brian]

Hi

I have a text box on a report that references three name
fields (first, middle, last). The code looks like:

=[LastName] & ", " & [FirstName] & " " & [MiddleName]

I want to apply bold formatting only on the LastName
portion. Is there something similar to the Ucase function
(ie =UCase([LastName]) & " "...) that can be used to
apply bold formatting to the font?

Any help would be greatly appreciated.

Brian

 

[fredg]

Hi

I have a text box on a report that references three name
fields (first, middle, last). The code looks like:

=[LastName] & ", " & [FirstName] & " " & [MiddleName]

I want to apply bold formatting only on the LastName
portion. Is there something similar to the Ucase function
(ie =UCase([LastName]) & " "...) that can be used to
apply bold formatting to the font?

Any help would be greatly appreciated.

Brian

It can not be done using Access as shipped.
You must either purchase and install a RichTextFormat control, or see
http://www.lebans.com
for his free workaround control.

 

[jacquie]

is it possible? how? thanks!

 

[Stephen Lebans]

For a form it's not really possible. FOr a single line solution on a
Report see:
http://www.lebans.com/mixbold-plain.htm

The proper method is to use RTF data within an RTF ActiveX control. THis
would require some coding on your part if the data currently exists as
plain text versus RTF encoded text. Not for the faint of heart!
http://www.lebans.com/richtext.htm
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.