Hide Field

[Fred in Thailand]

I have been searching the forum for hours and have found many solutions to similar questions but none seem to fit my problem.

I have a field on a layout. That field, Named Non-Active, is a check box with one value. I want to hide that field on the layout unless values in two other fields are met.

Field A = x

Or

Field B = x

Non-Active Field = Visible

Otherwise Field = Invisible

Very simple. All fields are in the same table and on the same layout.

This is making me feel like a complete morron again.

[bcooney]

Use the single row portal trick. Set up a portal without a border or vertical scroll bar. Put the field that you wish to "hide" in the portal. Build a relationship to the portal that is only valid when you want the portal row to show (hence displaying your field). In your case, create a calc field flag_ShowPortalRow = 1 if not isempty(Field A) or not isempty(Field . Use this calc flag in your relationship from the table that the layout is based on to the portal TO.

Take a look at JMO's article Visibility Trick

[comment]

I don't think a result of 1 would work well here. You want each record to show its own field, not the field from the first record. So something like:

Case ( Field A = x or Field B = y ; SerialID )

should be used to match the SerialID field on the other side of the relationship.