Skift farve ved ny post

?
Your going to have to explain that!

Do you mean the label at the top of the form or do you have a label in each record?

What happens if the field is already filled in?

I have the labels in the FormHead and the datafields in the DetailSection of the form.
When you open the form, it shows e.g. 5 posts, with the cursor positioned on a new record. In this case, the 2 labels shall be red. When data is entered in either field, the color of the label changes to black (to show that data is accepted). When the user then adds another post, by navigating to a "new record", the labels should turn red again.

In the Forms On Current Event
Dim lngRed As Long, lngBlack as Long


    lngRed = RGB(255, 0, 0)
    lngBlack = RGB(0, 0, 0)

If Not IsnUll(Me.SomeIDField) Then
  Me.TheLabel.BackColour = lngBlack
else
  Me.TheLabel.BackColour = lngRed
end if

Hvorfor ikke bruge betinget formattering på textbox'ene i? Er det ikke mere visuelt?

Betinget formatering lyder heller ikke dårligt, men sætter man ikke det som regel på formular-feltets egenskab fremfor i VBA koden?

jo!

På hver tekstboks kan du lægge en betinget formattering på denne måde:
Vælg "Udtryk" og skriv Form.Newrecord=True i udtryksfeltet.

Herefter angver du din farve mm.

/Thomas

Begge dele virker fint. Takker.