How do I change client settings for Access Runtime

Posted on 2011-04-28
Last Modified: 2012-06-21

Can anyone tell me how I can change the 'Client Settings' on a machine running the Microsoft Access Runtime?

I need to move to the next record after pressing the enter key rather than moving to the next field. However the 'Options' page isn't displayed  in the Runtime version.
Question by:afallppl
    LVL 56

    Accepted Solution


      You need to set any options via code and your own interface if you want to expose that to the user.
      In this case you'd use the setoption method of the application object:

    Application.SetOption("Move After Enter") = value

      Where value is don't move (0), next field (1),  or next record (2)


    Author Closing Comment

    Thank you. Worked perfectly.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    729 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

    19 Experts available now in Live!

    Get 1:1 Help Now