What is the conditional formatting doing? If it's just changing colors, could you just use backcolor with an if statement?

Something like
If DLookupValue = True then
FieldName.BackColor=RGB(255,0,0)
End If

Hi Adam
i have a conditional formatting set up like this

I was hoping to just issue a command like control.condition True. I guess I can abandon the Access conditional formatting all together and build it in VBA on my own.

I just realized it is really difficult to do that in VBA

Hi Sami, you could write a custom function that would return whatever you need, and use it inside the format condition.  For instance, a custom function could be:

     Function MyFunction1(ByVal num As Long) As String
         ...
         MyFunction1 = SomeValue
     End Function

And the format condition would be as pictured below.  A value from each row would be passed to the function, which would return a value pertaining to that row.

Thank you Kevin

I will try this and let you know

Hi Kevin

I finally have time to make this work, but I am stuck.
I have a Field on my DefaultT ShowColor Y/N
it is also on my MainMenu which is always open.

I am struggling to write the function you suggested on two fronts:
1) where to place it so it can pick up my ReligionCode.
2) what is the value the function should return so I can use it in my conditional Formatting "Expression is".

Thank you for your help.

PS. Can the "Expression is" take "AND" ?

Hi Kevin

I got is working with this:

TempVars("ColorOn")=True And [ReligionCode]='47'
in the Expression is

many thanks

I got it working with*