I have a large list of collectables I do and do not have (30,000+). I
have 6 fields, one of which is a checkbox field called "Mine" (yes/no
answer). In list view, if a field is checked "yes" I would like it to
be highlighted. How do I go about doing this? I am currently using FMP
pro 10. Thank you for your consideration,
Steve

Steve Berebitsky wrote:
In layout mode, right-click on the field, select Conditional Formatting,
add, and set your condition as 'value', 'equal to', 'yes', and then
select your fill color and say ok. This will highlight the field when
it is yes.

Or you can highlight all fields by selecting them all in layout mode,
right-clicking on a field, select Conditional Formatting, add, and set
your condition as 'formula': table::mine = "yes".


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker Certified Developer
Associate Member, FileMaker Business Alliance

"Howard Schlossberg" <howard (AT) nospam (DOT) fmprosolutions.com> wrote

Or to highlight the whole record, you'll need one big Field (set to not
allow user entry) stretched to fill the Body part, and set it behind all the
other Fields / elements. In older versions of FileMaker that would need to
be a Calculation Field with a Container result (and another Global Container
field storing the "highlight" colour as a small coloured graphic). In the
newer versions you could use the Conditional Formatting above instead.

Helpfull Harry )

When you want to highlight the field itself you don't have to reference to
it by name. Instead of that you can use the contstant 'self'
self = "yes".

--
Keep well / Hou je goed

Ursus

On 2010-04-22 04:07:55 -0400, "Ursus" <ursus.kirk (AT) ziggo (DOT) nl> said:

Thank you all very much. I am going evaluate and give them a shot. If I
cannot figure it out, you will hear from me again .