Importing graphics on checkbox

[Stephen Douglas]

Hi, Im completely new here and struggling with what should be a simple thing. I have a database with 2 layouts - 1 info 2 financial. When I tick an Invoiced check box (in layout 2) I want to display a graphic on layout 1 which says invoiced in big red letters - any Ideas?

[Raybaudi]

Hi

1) create a value list ( invoiced ) with only one item: Invoiced

2) create a field ( Invoiced )

3) while in layout mode ( info ) , set its font, dimension and color so that what you'll write inside it will appear good for you.

4) while in layout mode ( financial ) put there the same field, but format it as a checkbox with values coming from the value list ( invoiced )

Now in Browse Mode, if you'll check the box in layout financial, a big red "Invoice" will appear into layout info.

P.S. the field in the layout "info" can be a merge field, too.

[Stephen Douglas]

Thanks for that - I solved it by adding a calculation field to the Info layout with following formula! One of yours from another forum I thik - u r a very clever lady!

Case(

invoiced > 0 ; TextColor ( "INVOICED" ; RGB ( 255 ; 0 ; 0 ) )

)