Making one field bold in a concatanated string

  • Thread starter Thread starter abnewallo
  • Start date Start date
A

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?
 
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
 
Back
Top