Making one field bold in a concatanated string

[abnewallo]

This issue is in MS Access 2003

I have a string with the last name and first name fields concatanated. I
would like to bold the last name field only. Is there anyway to do this?

 

[Allen Browne]

The standard text box in Access 2003 and earlier cannot do that.

Stephen Lebans has a solution here:
http://www.lebans.com/mixbold-plain.htm

 

[Duane Hookom]

One possible solution is to make your text boxes invisible and use the Print
method of the report in the On Format event of the report section:

Assuming you have two hidden text boxes LastName and FirstName

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.CurrentY = Me.LastName.Top
Me.CurrentX = Me.LastName.Left
Me.FontBold = True
Me.Print Me.LastName
Me.FontBold = False
Me.CurrentY = Me.LastName.Top
'the 30 is used for spacing
Me.CurrentX = Me.CurrentX + 30
Me.Print Me.FirstName
End Sub