1 Reply Latest reply on Mar 27, 2009 12:58 PM by philmodjunk

    Appear or highlight fields when a selection is made -- Can this be done?

    adario

      Title

      Appear or highlight fields when a selection is made -- Can this be done?

      Post

      Hi,

       

      Some of our people are confused when they're entering data. To alleviate this I was wondering if I can make certain fields change colour once a selection has been made.

       

      For example if there are 13 radio buttons and #3 is selected only fields relating to #3 are highlighted so the data entry people don't have to read each area to see which might apply to #3.

       

      Thanks much

      Amy

        • 1. Re: Appear or highlight fields when a selection is made -- Can this be done?
          philmodjunk
            

          Look up info on conditional formatting. That feature will do it for you.

           

          Using your radio button #3 example.

           

          1. Enter layout mode.
          2. Right-click a field or group of fields that you want to change color when TableName::RadioButtonField = "#3 value"
          3. Select Conditional formatting.
          4. Click Add
          5. Select Formula Is..
          6. Click Specify
          7. Type in your expression:  TableName::RadioButtonField = "Whatever value is #3 in radio button value list"
          8. Select what ever format changes you want to happen when "radiobutton #3" is clicked.
          9. Click OK
          10. Return to browse mode and test.