Bold part of the field?

[SF]

Hi,

I am designing a contract form for printing. My report contain an unbound
filed whose row source is as follow:

="Subject: New Sub-agreement " & [Agreement Number] & " under the
USAID-funded Program "

Is it possible in Acess 2003 to bold only the Agreement Number?

SF

 

[fredg]

Hi,

I am designing a contract form for printing. My report contain an unbound
filed whose row source is as follow:

="Subject: New Sub-agreement " & [Agreement Number] & " under the
USAID-funded Program "

Is it possible in Acess 2003 to bold only the Agreement Number?

SF

Not in Access 2003 as shipped.
You can adapt the MixedBold report available at
http://www.lebans.com

Or install his free RichTextFormat control.

 

[Duane Hookom]

One method that might work is to place your bound text box for Agreement
Number where you want your text and make it invisible. Make its name
txtAgreementNumber.

Then use code in the On Format event of the report section:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.CurrentX = Me.txtAgreementNumber.Left
Me.CurrentY = Me.txtAgreementNumber.Top
Me.Print "Subject: New sub-agreement "
Me.CurrentY = Me.txtAgreementNumber.Top
Me.FontBold = True
Me.Print Me.txtAgreementNumber
Me.FontBold = False
Me.CurrentY = Me.txtAgreementNumber.Top
Me.Print " under the..."
End Sub