How to set a table (fields) to not-editable?

Posted on 2005-05-03
Last Modified: 2013-12-18
On the Form there is a radio button (among others) that can be set to YES or NO.
Below this button is a table (Subform) which should be editable when the user select YES.
But the table should be not-editable when the user select NO.

When I knew in advance what the user select it would be easy because I could create another Subform.
But in this case the Form is opened with an editable table and if the selection NO, the table should turn to a not-editable table.
Does anybody know how to do it?
Question by:didier20
    LVL 46

    Expert Comment

    by:Sjef Bosman
    Do you mean you have many fields in a table in your form, each table cell has a field? Set the property of the YES/NO-field to Refresh fields on keyword change, and use the value of the YES/NO field in the hide-whens of the whole table.

    Author Comment

    Yes, the table has lots of fields.

    I set the radio button field properties to "Refresh fields on keyword change"
    The fields in the table (in the cells) has the following hide when formula: matrel="N"
    matrel is the radio button field name.
    But it doesn't work, the field in the cell isn't hided even if I save the form.

    I guess there is something wrong with the "hide formula"
    I've already tried this:
    Field matrel := rb;


    Author Comment

    By the way: How can I give the radio button a default value?
    LVL 46

    Expert Comment

    by:Sjef Bosman
    What are the options you have for the radio button? If you have
        Yes | Y
        No | N
    or anything like that, then set the default value of the radio button as "N" (and NOT a plain N, which would mean the field with the name "N"!).

    Fields do NOT have a hide-when formula... Paragraphs do, and a table cell is one or more paragraphs, depending on the number of newlines you entered in the cell. The hide-when formula could just be

    Author Comment

    But on the radio button there is no option like: Set the default value.
    I want to set the default with "N" but where?

    The hide formula doesn't work till now but I will try later again.
    LVL 46

    Expert Comment

    by:Sjef Bosman
    Pardon? It is not an option, if that's what you're looking for. In the Designer, you don't have a place to set the Default Value? Must be there... where all default formulas are to be entered for fields.

    Author Comment

    Sorry, I thought it is on the Field's property window.
    I set following when it didn't work:
    Not Related |"N"

    But now it's ok, even the hiding.
    I only wanted to hide the fields and leave the table (frame/cells) there.
    Is it possible?
    LVL 46

    Accepted Solution


    Leave the cells visible? If your hide-when formulas hide all cells of a row, the row will be hidden. I have the following ideas about this:
    1) add in every cell a newline, so create a second paragraph in each cell; make the hide-when formula for this empty line the logical inverse of the cell's hide-when formula (which same as paragraph's hide-when).
    2) do the same, but only for 1 cell per row
    3) add a column that's always visible, i.e. without a hide-when formula, e.g. with a space or a line number in it

    If option 3 isn't suitable, then try 2.

    Author Comment

    It works.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    HP DP 7.03 and lotus collaboration suite 9 3 140
    Lotus Notes - Broken Links report 5 182
    Lotus notes email code 2 169
    Lotus Domino server 11 52
      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now