Access 2021 propety sheet will no longer display

[AndyR]

I was running 2007 without a problem but after updating to 2021, the property sheet (in Design) quit working after a couple of days.

I do have multiple monitors (which was initally working well with 2021) and I tried the Immediate:
CommandBars("Property Sheet").Top = 0
CommandBars("Property Sheet").Left = 0


I appreciate any advice as I tried uninstalling both 2007 and 2021, then re-installing 2021 but
nothing seems to work.

Thanks so much!

[Micron]

I imagine that you haven't used the second monitor since you updated Access? You'll probably find it if you use the second monitor. Or try this in the immediate window (press enter after the line(s):

CommandBars("Property Sheet").Enabled = True
and if not,
CommandBars("Property Sheet").Position =msoBarTop

By chance you have not coded to hide the application window?

[AndyR]

Thanks for your Quick Reply.
It's not on the other monitor.

It's not hidden in the application that I know of.

Error message when executing the code:



Any more thoughts will be appreciated.

[AndyR]

Error snipped didn't post

Run Time Error 5:
Invalid procedure call or argument.

[Micron]

What I posted was not intended for code. I said to use the immediate window. You'd have to post the code for evaluation if you want to go that way.
You cannot paste images into this outdated forum software. See How to attach files at the top of the window. Please don't post pics of code though. Use code icon (#) on posting toolbar.

[AndyR]

Problem solved by a smart friend.

In Immediate Mode:

CommandBars("Property Sheet").Width =500

[AndyR]

I did execute from the Immediate mode when I got the error.
Thanks for your help. Changing the width solved the problem.

[Micron]

Hmm. That was another suggestion I found when I searched but I forgot to copy it. The other 2 suggestions came from other old threads in here so much poking around and that one got dropped. I forget where I saw it.

[AndyR]

Thanks again.