changing the back color of a textbox on a continuous form (1 Viewer)

[Terkpeh1990]

please am developing this application and have a continuous form with these three textboxes namely procurement_id, request, and status.

i want to be able to change the back color of status textbox to
1. red if it's value "PENDING"
2. green if it's value is "COMPLETED"
3. Yellow if it's value is "YET TO BE PROCESSED"
4. brown if it's value is "SUSPENDED"

please am new to vba . Any help will be greatly appreciated .

 

[isladogs]

Have you tried conditional formatting? No code needed


Sent from my iPhone using Tapatalk

 

[Terkpeh1990]

Have you tried conditional formatting? No code needed


Sent from my iPhone using Tapatalk

have no idea how to do that . any help can be greatly appreciated . thank you

 

[Terkpeh1990]

Have you tried conditional formatting? No code needed


Sent from my iPhone using Tapatalk

thanks very much . it worked like magic

 

[isladogs]

Excellent. You obviously worked it out without help.
Good to have a simple solution...