0

Something has gone terribly wrong with my VBE layout. I originally closed my Project explorer and was trying to figure out how to restore it when I made some changes under the window tab of the ribbon.

I've restored the Project explorer but I can't for the life of me reset my code window to display only the current module I'm working on. The resulting layout is hideous, truly atrocious, and difficult to work with.

disgusting VBE display

I've already tried resetting my registry key for VBA as recommended here to no avail. I believe I clicked on either Cascade or Tile Vertically to make the code block appear this way.

Any help would be greatly appreciated.

W.Harr
  • 303
  • 1
  • 4
  • 15

3 Answers3

1

You've never hit 'Restore Down' before on the Windows controls? Click it again (it will now be called Maximise) to put things right.

CLR
  • 11,284
  • 1
  • 11
  • 29
1

Try setting the code windows in your layout to how you like them. Then add a module to your project, then exit Access. It seems to save the layout at that point.
You can then delete the empty module.

David Anderson
  • 319
  • 3
  • 3
  • 1
    Funnily enough, this doesn't answer the OP's question, but trying to search for a solution to my problem, where the VBE layout in Access kept forgetting my changes, lead me to this page, and your post resolved my problem – emjaySX Jun 30 '23 at 03:41
0

Click the square box of any of the windows in the upper right corner for it to fill the window, and then you can navigate using the project folder structure to the left, or the Window menu at top. Windows can be dragged and "docked" at different positions. For step by step instructions on how to dock windows in the VBE, including video see this site, for example

Tony M
  • 1,694
  • 2
  • 17
  • 33