June 22, 200718 yr 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.
June 22, 200718 yr 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
June 22, 200718 yr 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.
Create an account or sign in to comment