Columns in MIcrosoft Access 2007 QBE grid

Dumb question? Is there any way of controlling the number of columns Access 2007 displays when you open up the Query Design grid? It seems to be quite arbitrary, especially for queries created previously.  If I have the shutter bar open (which I do almost all the time, to view and select database objects), the QBE grid often extends beyond the right-hand side of my screen, with numerous empty columns. It is infuriating to have to scroll to resize it and/or delete unused columns. Why can't it just resize to available screen width and adjust this according to whether the shutter bar is open or closed?
MikeGatehouseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamMandenoCommented:
Hi Mike
The empty columns are there just for your convenience, so you can add fields without first adding columns.  I don't believe there is any way to change the number of empty columns that show up initially.
I don't really see what the problem is.  The empty columns are not really part of your query, and there is no need to scroll across to look at them.  If there are empty columns there, you can be sure there is nothing to the right of them (unless you have just inserted some empty ones).
I'm not sure what you mean by the "shutter bar".  Do you mean the navigation pane (NavPane) on the left-hand side?
--
Graham
0
peter57rCommented:
I agree - why do you feel the need to delete unused columns?
0
MikeGatehouseAuthor Commented:
I suppose it's not a problem: just a pesky annoyance! I like to see and use the mouse on  the Max/Min/Close buttons on the grid window-pane and the right-hand scroll arrow. As it is, they are often hidden off-screen to the right. And the Access behaviour seems arbitrary. What's the convenience of having a seemingly random number of unused columns as against the inconvenience of not having the usual window controls?
0
peter57rCommented:
Are you sure your A2007 is fully up to date?
In my A2007 the query view is very well behaved in that it displays the design or datasheet view in exactly the same size as I last saved it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MikeGatehouseAuthor Commented:
Thanks, Peter, you are right. My database was originally created in Access 2003 and contains a large number of queries. It is the original ones which seem to open with the excess columns in the QBE grid (although I can't think that they had that number of columns when originally created). Once I have opened and resized or modified them in A2007, they open thereafter at the width when last saved.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.