Perform find and check color of text

[Lord HellFire]

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

[comment]

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.