In a Microsoft Access project (.adp), you can add the property to the AccessObjectProperties collection of the CurrentProject object by using the Add method. accdb), you can add the property by using the CreateProperty method and then appending it to the Properties collection of the Database object. To set the AllowBypassKey property by using a macro, you must create the property in the following way: You can set this property by using a macro or VBA code. Click Current Database, and change the settings for the current database. Non-breaking spaces are not used for hyphenation and are not expanded if the text is justified. The Enter key is used in MS-Word as a way of saying 'new paragraph.' The Shift-Enter combination is used in MS-Word as a way of saying 'new line. Ctrl+multiplication sign (only on number pad) Run macro field. + Shift + Return or Ctrl + Shift + Enter: Enter a formula as an array formula: Esc: Cancel an entry in the cell or formula bar: Ctrl + A: Display the Formula Builder after you type a valid function name in a formula + K or Ctrl + K: Insert a hyperlink: Ctrl + U: Edit the active cell and position the insertion point at the end of the. To change these options, do the following: Click the File tab, and then click Options. Ctrl+Shift+minus sign (-) Non-breaking dash (is not used for hyphenation). The AllowBypassKey property uses the following settings.Įnable the SHIFT key to allow the user to bypass the startup properties and the AutoExec macro.ĭisable the SHIFT key to prevent the user from bypassing the startup properties and the AutoExec macro. When you open a database while holding down the SHIFT key, many of the options that are set on the Current Database page of the Access Options dialog box are bypassed.
#Open office enter vs shift enter code#
Disable the Bypass (SHIFT) key by using Visual Basic for Applications (VBA) code to set the AllowBypassKey property to False. When your database has multiple users, you can prevent users from bypassing startup options. When you bypass the startup options, the AutoExec macro does not run. If you add an Access macro named AutoExec to a database, the macro usually runs every time that you open the database.
#Open office enter vs shift enter how to#
The designated custom Ribbon is not displayed.Īll default Ribbon tabs are displayed regardless of the setting.Īll default shortcut menus are displayed regardless of the setting.įor more information on how to set options for the Current Database, see the article Set user options for a current database from a centralized location. When available, the designated Web form is not displayed, and none of the form's event procedures are run.Įven if this option is not selected, the Navigation Pane is displayed. Is available only when a designated Web form is present. The designated form is not displayed, and none of the form's event procedures are run. The custom application icon is not displayed. The custom application title is not displayed. The following table lists each setting on the Current Database page and how they behave when you open the database while holding down the SHIFT key.īehavior when startup options are bypassed Note: You may need to close and reopen the database for the changes to be effective.
0 kommentar(er)
