I want to recreate the Show all Records button (with text) on my layout.  What's the script behind the conditional formatting?  When all records are showing the icon is grayed out.  If I use text in place of the icon how do I gray out the text when all records are showing?

Compare:

http://www.filemaker.com/11help/html/func_ref2.32.34.html#1029478

http://www.filemaker.com/11help/html/func_ref2.32.79.html#1031667

I'm not articulating my question correctly.  If the total records equal 4 and I do a Find resulting in  only 2 records I want my button text to be grayed out.  When I use Get(FoundCount) and or Get(TotalRecordCount) it returns 4 (regardless of my Find result).  How do I identify the resultant number of records from my find?  Maybe I'm using it wrong. Can you advise?  My user name and password on the attached is admin.

 

 

FoundCount.zip

When I use Get(FoundCount) and or Get(TotalRecordCount) it returns 4 (regardless of my Find result). 

 

 If your found set contains 2 records, then Get ( FoundCount ) returns 2. You would see that in your file too if you only set the calculation fields to be unstored.

 

 

In any case, you don't need the calculation fields for conditional formatting; just set the button text color to change to grey when =

Get ( FoundCount ) = Get ( TotalRecordCount )

Many thanks for your help... mp