Changing the font of a field in a form based on another form (1 Viewer)

miacino · Sep 21, 2018

If my form field [urgency] is "time critical", AND my calculated Text53 field calculates >24, I would like to turn the font red.

How off am I?

Private Sub Text53_AfterUpdate()
If Me.Urgency = "Time Critical (<24h)" And Me.Text53 > 24 Then
Me.Text53.ForeColor = vbRed
End If
End Sub

Uncle Gizmo · Sep 21, 2018

Your thread was marked solved? I assume it is a mistake, and have unmarked it. If you wanted it Mark "Solved" then please reset it again..

missinglinq · Sep 22, 2018

You write

miacino said:
If my form field [urgency] is "time critical"

But then your code is

miacino said:
If Me.Urgency = "Time Critical (<24h)"...

So is your first condition supposed to be

[urgency] is "time critical"

or

Me.Urgency = "Time Critical (<24h)"

Linq ;0)>