If field a has data then..

[Leather Knight]

How do I make so if field "A" has data in it, then field "B" will show up, but if field "A" is blank, then so is field "B"? Field "B" is a global.

Thanks

[comment]

"Show up" and "blank" are not antonymous.

[Leather Knight]

Let me elaborate:

If you have a set of check boxes, and nothing is checked, then the words "Needs Repair" show on the form, however, if there is a box checked, then you see nothing.

[Raybaudi]

Case(

IsEmpty ( checkBox ); "Needs Repair"

)

[comment]

It should be an unstored calculation field - not global.

In version 9, you can do this without the extra field: simply type "Needs Repair"on the layout, and apply conditional formatting to hide it (i.e. merge with the background) when the condition is true.

[Leather Knight]

Now if the checkbox has boxes checked, instead of "IsEmpty", what would I use? I tried "IsValid" but that doesn't work.

[Raybaudi]

not IsEmpty

[Leather Knight]

Hmm, would think I would have known that one.... :