Send to Word not listening to Access???

[Gina Whipp]

Hello All,

The below code is on the On Format and On Print of the report Detail
section. Works beautifully as long as I preview and print from within
Access. However, if I transfer to Word and 1(one) txtPromiseDate is
193(red), then the whole coulmn is 193(red). What am I doing wrong?

Thanks in advance,
Gina

On Error Resume Next
If (Me.txtNC) = 4 Then
Me.txtPromiseDate.ForeColor = 193
Me.txtPromiseDate.FontWeight = 700
Else
Me.txtPromiseDate.ForeColor = 0
Me.txtPromiseDate.FontWeight = 400
End If

 

[Gina Whipp]

Nope, but I will now.

Gina:

Have you tried only putting the code in the On Print event rather than in
both places?