Re: Forms 4.5 problem

Muhammad A. Malik wrote:
>
> Is there any solution to the following Forms 4.5 problem:
>
> In a multi-record block associated with a base table, I want to have
> distinct background colors for each distinct value in a field for each
> record.
>
> For example in a field containing the following data:
>
> Value Background color
> 1 Green
> 2 Red
> 3 Blue
> 2 Red
> 1 Green
> 4 Yellow
> 3 Blue
> 1 Green
> 2 Red
> 4 Yellow
>

I'm not at work, and so can't try it - but I'd try a post-query trigger, which test the value - and sets the field property accordingly. I guess you also need a when-validate-item if the user can change the value too.

Hope this helps,
Chris Received on Wed Jul 17 1996 - 00:00:00 CEST