text box back color on a continous form

[favor08]

Can I have a text box on a continous form called txty9 and say where the value is null make the backcolor = 16777215 esle make it 255.

I put this but the color stays white even when a item is enter in that field for a particular line.

So now I have 2 lines that have a value in txty9 but 11 are null. So 2 should be read and 11 should show white.

Private Sub Form_Load()
  If IsNull(Me.txtDone) Then
    Me.txtDone.BackColor = 16777215
  Else
    Me.txtDone.BackColor = 255
  End If
End Sub

[nico5038]

Continous forms have a will of their own.
Best to use the Conditional Formatting option from the Format menu.

Nic;o)

[favor08]

Continous forms have a will of their own.
Best to use the Conditional Formatting option from the Format menu.

Nic;o)

it only seems to read the first line.

[nico5038]

Conditional formatting will process all rows.
What are you using ?

Nic;o)