SOLVED

Conditional Format subform in datasheet

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3148666%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EConditional%20Format%20subform%20in%20datasheet%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3148666%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECan%20a%20conditional%20format%20be%20set%20in%20a%20subform%20in%20datasheet%20view%3F%26nbsp%3B%20I%20see%20the%20conditional%20formatting%20button%20is%20there%20but%20when%20I%20set%20a%20format%20it%20doesnt%20work.%26nbsp%3B%20I%20even%20shade%20a%20field%20without%20conditional%20formatting%20and%20that%20doestn%20work%20either.%26nbsp%3B%20I%20imagine%20I%20am%20doing%20something%20wrong.%26nbsp%3B%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ethank%20you%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3148666%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3Eaccess%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Super Contributor

Hello,

 

Can a conditional format be set in a subform in datasheet view?  I see the conditional formatting button is there but when I set a format it doesnt work.  I even shade a field without conditional formatting and that doestn work either.  I imagine I am doing something wrong.  

 

thank you

 

2 Replies
best response confirmed by Tony2021 (Super Contributor)
Solution
yes, something is wrong alright.
you're conditions doesn't filter the data.
I got it working. I am not sure what I was doing wrong. Maybe computer needed some sleep!