I have a row of 12 buttons, each of which finds a set of records. When I click a button, it momentarily changes color, but I would like it to remain a different color when the particular set of records is found, so that the user knows which set is operating.

I have set a conditional formatting for the button to change the color of the button and text, but am not sure which formula to apply. I figured a variable to toggle the button on and off using Abs ($$color -1), but this only applies to a single button. What I want to do is loop through the other buttons and turn them all off when the button pressed comes on.

Does anyone know a script which does this?

Conditional formatting in version 8?

I'm not sure exactly what you require here - you state the pressed button should change colour [on] and all the other buttons to be turned off [change colour?]. They are "off" already so don't need to be changed?

Do you just want the pressed button to be a different colour?

I'm not sure if this is the same thing, but I didn't want to start a new topic.

I am creating a database, and I have designed a set of buttons with icons in the centre.

I have also created an inverted set which I would like to Appear when clicked on, but only for a brief moment. Is this possible?

If they are only to appear "inverted" for a brief time then this will be done when the button is pressed without another set of icons being used. A button shows its complementary colour when pressed.

I realise it shows a default colour when clicked. But is there anyway to reveal a different picture (inverted button).

When I say "inverted" it's not really, I have a purple button with a grey icon in the centre and when pushed I have a Grey button with a purple icon to be shown. If it isn't possible I will just have to explain to the boss but I'm going on his brief.

Thanks for the help.