Unable to select SetValue for a submacro in access2016 RRS feed

  • Question

  • 'This is the submacro code I would like to set up in Access 2016 Submacro: OK SetValue <---- Not available from the dropdown list Item = [Visible] Expression = No End Submacro

    • Edited by Jerrykco2 Monday, April 2, 2018 4:30 PM
    Monday, April 2, 2018 4:30 PM


All replies

  • In the Design Tab of the Ribbon, did you first activate (click on) the Show All Actions otherwise that command will not be shown.

    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    • Marked as answer by Jerrykco2 Monday, April 2, 2018 9:24 PM
    Monday, April 2, 2018 4:45 PM
  • Pardon me but is [Visible] the name of a field in your table or control on your form?

    I was just wondering if you meant to use SetProperty instead.

    Just curious...

    Monday, April 2, 2018 5:43 PM
  • Thanks <g class="gr_ gr_18 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" data-gr-id="18" id="18">Daniel</g>. Hadn't gotten far enough to replace visible with a control.
    Monday, April 2, 2018 9:41 PM