Continious forms

[Chris]

Howdy group, it's Friday and I'm just putting the finishing touches on a
database and doing some final test runs.

I have a continious form, the continious form has a check box and a
textbox - these are linked to a table. When the checkbox is ticked, I would
like the backcolour of the corresponding textbox to change colour.

IF I code
If me.chkStandard = -1 Then
me.txtStandard.backcolour = "1234"
End IF

All the textboxes change colour instead of the corresponding textbox.

 

[BruceM]

Try conditional formatting. Help has more information on the subject. In
general you will be setting the format of the text box by using an
expression something like:
[CheckBoxName] = -1
and setting the background color to your choice.
-1 is True, 0 is False for a Yes/No field.