Conditional Formatting

[jaaret]

I struggle with conditional formatting. I can usually get it to work but I struggle to get there.

I have this in the Conditional Formatting box but it's not working when [txtHR]=0

[Forms]![pfrmProjectTaskDetails]![sfrmTaskResources]![txtHR]=0

This same protocol works on in other conditionally formatted fields on other forms. What's the best way to write a conditional formatting expression?

 

[ZmrAbdulla]

You can easily do it from the wizard

Formatting > Conditional Formatting

BTW, your code doesn't make sense. Tell us what are you trying to do
or if you need vba then see

http://blogs.msdn.com/frice/archive/2004/06/08/151178.aspx

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[jaaret]

I am using the wizard.

Expression is: [Forms]![pfrmProjectTaskDetails]![sfrmTaskResources]![txtHR]=0

I've used a similar expression in the Wizard and it has been successful.

 

[ZmrAbdulla]

I am not sure which wizard you are using.
The wizard that I am talking about is not supposed to do like this. see it here

http://support.mckendree.edu/Docs/Microsoft Access Manual.htm#_Toc532183815

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[TheAceMan1]

How are ya jaaret . . .

. . . try this:

[blue][sfrmTaskResources].Form![txtHR]=0[/blue]

Out of curiosity are to trying to [blue]conditional format the mainform[/blue] via txtHR?

See Ya! . . . . . .