Results 1 to 3 of 3
  1. #1
    BruceUK is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Posts
    48

    Using function keys when debugging VBA code - problem with Windows 10

    I'm using Access 365 under Windows 10. I'm trying to debug some VBA code by setting a breakpoint and stepping through the code statement by statement. Under previous versions of Windows and previous versions of Access, I was able to use the shortcut function keys F8 and F9, either alone or in conjunction with the Shift and Control keys, to step through the code in various ways. But with Windows 10, when I press the F8 key to execute the next statement, a popup appears with something to do with the Cortana feature! Something equally irrelevant happens with another popup if I select a statement and press the F9 key to set a breakpoint there.



    Can someone explain what I need to do to establish the proper use of these function keys when debugging VBA code? I'll be grateful for any suggestions!

  2. #2
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    your keyboard probably has a function key that switches between modes. On mine its called "FN" and its at the end of the F keys (after F12). If you hold this key down the F keys should behave like you expect.

    Its very annoying and I've not found a way to make the F kays default to the original options.

  3. #3
    BruceUK is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Posts
    48
    Many thanks for the quick reply! Yes my keyboard does have an 'FN' key (although on mine, it's located next to the Ctrl key). I'd never paid any attention to that key before. Anyway I tried using it and it does restore the expected behaviour of the F keys.

    Thanks again.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Debugging VBA code
    By Lou_Reed in forum Access
    Replies: 8
    Last Post: 05-03-2017, 11:25 AM
  2. Debugging - F8 not stepping through the code?
    By djspod in forum Programming
    Replies: 5
    Last Post: 03-15-2017, 09:05 AM
  3. problem in code for if function
    By majidrazlighi in forum Programming
    Replies: 3
    Last Post: 05-02-2016, 06:22 PM
  4. Replies: 5
    Last Post: 03-15-2014, 05:27 PM
  5. VBA If Then function - problem in code
    By Knelou in forum Access
    Replies: 63
    Last Post: 09-25-2013, 10:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums