apply bold to part of concatenated string

  • Thread starter Thread starter Brian
  • Start date Start date
B

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
 
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?
Click to expand...

No. Unfortunately you can't mix fonts or bolds or italics in a normal
Access textbox. You'll need to either use separate textboxes for the
fields, or use a Rich Text Format control (which isn't a native part
of Access but can be obtained from Microsoft or from third parties).
 
John, never say no. ;-) Our good buddy Stephen has something to do this on reports. (Although I'm not sure it is worth all of the
hoops you have to jump through compared to a rich text control.)

Brian, take a look at http://www.lebans.com/mixbold-plain.htm.

For forms, I believe John is correct, you'll need a rich text control. And Stephen has one of those too. Take a look at
http://www.lebans.com/richtext.htm.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

John Vinson said:
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?
Click to expand...

No. Unfortunately you can't mix fonts or bolds or italics in a normal
Access textbox. You'll need to either use separate textboxes for the
fields, or use a Rich Text Format control (which isn't a native part
of Access but can be obtained from Microsoft or from third parties).
Click to expand...
 
Back
Top