Allow field to generate change in screen colour in Access

[BTQMJM]

We currently use an Access database to monitor project expenditure in
particular sections.

I would like to be able to automatically generate a change in screen colour
when certain payments are made, therefore the 'paid' field being populated.

Does anyone know how this can be done or even if it can be done?

Many thanks

BTQMJM

 

[Marshall Barton]

We currently use an Access database to monitor project expenditure in
particular sections.

I would like to be able to automatically generate a change in screen colour
when certain payments are made, therefore the 'paid' field being populated.

If the form is displayed in Single View, then you can use
the payment text box's AfterUpdate event AND the form's
Current event to set a text box's or the form's BackColor.

If <some expression> Then
Me.BackColor = RGB(255, 220,220) 'Pink
Else
Me.BackColor = vbWhite
Enf If

 

[Dale Fye]

Or you could use conditional formatting of a textbox based on the value in
that box, whether it has the focus, or some other critieria (expression).

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.