First Published 24 June 2023
Periodically, posts appear on various forums where users have lost the property sheet and are unable to retrieve it. For example:
Property Sheet Does Not Display by mredmond13 (June 2018)
Property Sheet Does Not Show by valeryk2000 (June 2023)
The Access property sheet is displayed when you click Property Sheet on the Form Design or Report Design ribbon.
By default, it is docked on the right side of the screen.
However, if preferred, it can be docked on the left of the screen or made to float
It can also be resized and in extreme cases, shrunk to almost nothing
It is also possible to move it completely off the top or bottom of the screen or onto the desktop on a different monitor.
It will retain the latest setting until moved again.
Occasionally this can cause issues where someone forgets the property sheet location.
• try pulling the right edge of your form to the left to make space for the property sheet
• if you have hidden the application interface, try restoring the ribbon and navigation pane
• try changing the resolution temporarily, then change it back. That usually fixes the issue
• use VBA code to reset the position – this ALWAYS works
The following code suggested by Josef Poetzl has been reproduced with his permission:
'find the current position and setting for the property sheet
With Application.CommandBars("Property Sheet")
Debug.Print "Top, Left, Width, Height:", .top, .left, .Width, .Height
Debug.Print "current position:", .Position
In this case, the property sheet is on a secondary monitor (Left <0) and is floating (Current Position = 4)
The allowed msoBarPosition values are:
• msoBarLeft = 0
• msoBarRight = 2
• msoBarFloating = 4
So to reset the property sheet to the right of the screen, you just need one line of code:
Application.CommandBars("Property Sheet").Position = msoBarRight
Using the msoBarRight expression requires the reference library Microsoft Office xx.0 Object Library.
However you can use its value (2) without first setting the reference.
Application.CommandBars("Property Sheet").Position = 2
After running that code line, the previous code will show something like this
I would be grateful for any feedback on this article including details of any errors or omissions
If you have any comments or questions, please contact me using the feedback form below to send me an email
Colin Riddington Mendip Data Systems Last Updated 24 June 2023
Return to Code Samples Page
Return to Top