MS Access - Cannot widen tables/queries column

KrazyKasper

Board Regular
Joined
Aug 28, 2008
Messages
87
While working in MS Access I reduced the column width for the table/queries to have more room in the work area.</SPAN>
It appears I moved it too far to the left and cannot move it back to make a wider column for the table/queries list.</SPAN>
I tried "grabbing" the column as I did before but it does not even show the crossbar.
I tried Ctrl-z but that did not work.
Also tried right-clicking on the column but there is no option to change the column size.
And I looked in "options" but found nothing related to changing the column size for the queries/tables column.
Any suggestions?</SPAN>
Thanks.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
For queries, you could recreate them pretty easily.
Just change your query to SQL View, and copy that SQL Code.
Then, create a new query, go to SQL View, and paste the code there.

That should re-create a new query with the default column widths.
 
Upvote 0
It is not a column in a query or a single query.
I link to and have created many tables and created may queries in this database.
It is the left-hand column that lists all of the queries and tables.
 
Upvote 0
I believe what you are referring to is known as the "Navigation Pane".
There is also an option to hide that in the Current Database settings.
Have you tried hitting F11?
 
Upvote 0
I did try F11 and it hides/unhides the column, but it doesn't change the width (which currently is about 1/3").
 
Upvote 0
Thanks. I did try restarting MS Access as it suggested but that did not work. What did work was closing the search bar.
 
Upvote 0

Forum statistics

Threads
1,221,860
Messages
6,162,479
Members
451,769
Latest member
adyapratama

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top