Conditional Formatting
Experts,
I have a form in split mode with datasheet on bottom.
I am trying to use conditional formatting to color the column [Issue_CSM] if it does not equal either of the other 2 columns.
Some cells are null though.
Any ideas? thank you
I have a form in split mode with datasheet on bottom.
I am trying to use conditional formatting to color the column [Issue_CSM] if it does not equal either of the other 2 columns.
Some cells are null though.
Any ideas? thank you
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Mbizup, thanks for the response. Do I need to use control source names?
ASKER
I got it. It is not the control names...just the field names.
It works! thank you!!
It works! thank you!!
Good question!
Offhand - For CF, I beleive you need the field names (control sources) versus the textbox names.
(If that doesn't work out, switch to using textbox names...)
I'm going to double check myself to verify...
Offhand - For CF, I beleive you need the field names (control sources) versus the textbox names.
(If that doesn't work out, switch to using textbox names...)
I'm going to double check myself to verify...
Haha! I thought so... but couldn't quite remember (I don't recommend getting old). I don't use CF much.
Glad you've got it sorted...
Glad you've got it sorted...
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
I used "Issue_Sent" in my post.
Your post has "Issue_Sant" (so you may need to correct my field name)