hide if empty

[Gaz 007]

I have a layout called invoice which I obviously use to invoice people hoever some people have an agent and some people don't so is it possible to hide a field and text label i.e. if agent = null don't show the field on the layout?

[Breezer]

Create a field to check if the agent field is empty, such as,

Agent_status = If (not IsEmpty(invoice_Agent);1;0)

Have another field that is auto-enter with a value of "1" or a global field. I will call this field, CommonOne. If you use a global field, set it to "1" before hosting.

Create a self relationship and relate Agent_Status to CommonOne. In the invoice table, use a poral to cover the field you want to toggle.

Invoice.zip

[Genx]

You don't need the 1 ; 0.

IsEmpty() is a boolean test that returns 1 if true and 0 if its empty

What your effectively typing if you use the If Function is:

If(not IsEmpty() ; If not IsEmpty() returns 1... 1 ; If not IsEmpty() returns 0... 0 )

As opposed to not IsEmpty()

[Gaz 007]

sorry I don't understand..... can u explain this 2 me

[Lee Smith]

You might get what you are wanting by using the Slide feature.

Layout Mode

Select the Field

Main Menu >> Format >> Set Slide Printing.

HTH

Lee