I've noticed that in databases I design, people often end up in the find mode and don't realise. Or they forget. So they perhaps click the find button get a bit confused by something and then forget they're searching. The difference between the browse layout and the find layout isn't great!

I was thinking of changing the find layout - maybe a background colour to make sure people are aware of where they are. But I can't figure out how to do that. Any thoughts?

Or other solutions?

It can't be done using a calc field as FM stop doing calcs in find mode, so here's a scripted way.

ColouredFind.fp7.zip

Thanks. I kinda get the concept but I'm having problems getting it to work - perhaps because I've never worked with container fields before.

So I created three fields:

g.backgroundcolour

g.findcolour

g.browsecolour

Then the script becomes:

Allow user abort [Off]

Set field [Members info::g.backgroundcolour;/*Members' info::g.findcolour*/

Enter find mode

Pause

Perform find

Set field [Members info::g.backgroundcolour;/*Members' info::g.browsecolour*/

I see what that's doind - you define what the find colour and browse colours are and then the script sets the background colour to be one then the other.

But it isn't working. And I think that's because I'm not sure how to define the find and browse colours.

I see in your example, that you've defined the background colour in the layout mode. But how are you defining the find and browse colours? I can't see how that's happening. In layout mode, they are white. In browse mode they're different colours.

Have you inserted a picture - that's actually just a colour? Or is there some easier way to make a container field have a colour? I'm a bit stuck!

Thanks

Nicole

I pasted a coloured box into the two globals.

Sorry for being dense, but that's what I don't see how to do. How do you paste a colour (or a coloured box) or anything into the field?

Where are you getting the coloured box from? I tried creating a table cell in word and colouring the cell a colour, copying it and then pasting, but that didn't work. So then I created a square in fireworks - no joy. Then I thought, I'll copy your square.....nope.

Bit stuck. So I've attached a zip file of my database. Hope it works.

thanks

Nicole

mwf.fp7.zip