Multiple Text Color Change When Field Value Changes

[Angel19]

Hello All,
I am fairly new to Access 2010. I have created a client database and am trying to get the fields in an entire "row" to change to red when the value of one field changes. This is what I have

Client ID/Date Became Client/Which Attorney?/Client(s)/Type of Case/Status

Now in the Status field user can choose the following: Open, Closed, or Inactive

What I want is for the entire "row" to change to red text when the Status field changes to Closed.

How do I make that happen? Please help!!!

 

[vbaInet]

By using Conditional Formatting. Have a look:

http://office.microsoft.com/en-us/a...using-conditional-formatting-HA010208133.aspx

 

[Angel19]

This doesn't work. I have read this article already. I cannot shift and select more than one field at a time. The result is that only the status field changes to red when closed is selected. None of the other fields change. I have tried conditional formatting with each text box but I must be using an incorrect expression to make it work.

 

[vbaInet]

Expression Is
[Status] = "Closed"

That's what your Conditional statement should be. You select Expression Is, not Field Value Is.

 

[Angel19]

That did it!!! I was using the wrong code. Thank you so much!!!

 

[vbaInet]

You're welcome!

Welcome to the forum by the way.

 

[Angel19]

Thank you! I'm glad you guys are here!

 

[vbaInet]

And we're glad to have you here.