Yes/no checkbox event when check

[darwin]

hi

I have a checkbox, and a textbox

when check the checkbox then the backcolor in the textbox must be red

I try this with no succes, checkbox name is Ma1 and textbox name is Ma1tekst

Private Sub Ma1_AfterUpdate()
If Me.Ma1 = 1 Then


Ma1tekst.ForeColor = red
End If
End Sub

[June7]

Should use Conditional Formatting for this. No VBA required.

[darwin]

with conditional formatting you mean the expression bouilder ?

[June7]

No, I mean Conditional Formatting from the Format tab on the ribbon.

[darwin]

ok yes but an issue, when I select/mark the yes/no checkbox, the conditionel formatting is not posible ??

when I select/mark a textbox no issue ?

[June7]

The Conditional Formatting should be set on the textbox. The conditional expression for changing the color would be:

[Ma1] = True


Also note, the numeric constant for True/Yes in Access is -1, not 1.

[darwin]

Great thanks I learn every day