Hi

I'm trying to make Filemaker perform a find on text of a specific color, so it can omit the records it finds with text in a given color.

Current script:

----

* [color:red]Show All Records

* [color:red]Enter Find Mode [Pause] [color:brown]//Search text is entered here//

* [color:red]Perform Find

* [color:red]Go To Record/Request/Page [First]

* [color:red]Loop

* [color:green]Go to Field [database::fieldname]

* [color:green]If [Get ( ActiveFieldContents ) = TextColor ( database::fieldname ; RGB ( 0 ; 255 ; 0 ))] [color:brown]//should check if text is green//

* [color:blue]Omit Record

* [color:green]Else

* [color:blue]Go To Record/Request/Page [Next;Exit after Last]

* [color:green]End If

* [color:green]Exit Loop If [Get ( FoundCount ) = "0" ) [color:brown]//To prevent it looping forever, if all records have been omitted//

* [color:red]End Loop

It doesn't check if the color is correct; it just checks if the text is the same.

I want it to check the color.

I can't find any other functions, that compare the color of the text or extract the color information from text.

Help?

Kind Regards

Lord HellFire

'Eternal Life or Your Money Back

Try the GetAsCSS() function. Filemaker ignores style when comparing data. That's a good thing, because otherwise 1 + 1 = 2 would be false when the result is formatted to display in bold.