Allow field to generate change in screen colour in Access

  • Thread starter Thread starter BTQMJM
  • Start date Start date
B

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
 
BTQMJM said:
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.
Click to expand...


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
 
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.
 
Back
Top