By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

Automatically "fit" query design view table/field grid columns.

P: n/a
In query DESIGN view, how do I automatically "fit" the columns in the
table/field grid to the lengths of the table and field names (including any
functions applied to the fields). I am not talking about the query results.
I am talking about sizing parts of the query DESIGN view, so that they are
readable (long table and field names that get chopped off, long criteria
specifications that get chopped off, ...), and saving the sizing so I don't
have to redo it every time I open the query in DESIGN view. I'm using MS
Access 2003.
Jun 28 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Highlight all of the columns then do a best fit on any one of them. It
doesn't save.
--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

"NowItsWhatever" <gl*****@verizon.net> wrote in message
news:pmnog.18142$Gh.12982@trnddc02...
In query DESIGN view, how do I automatically "fit" the columns in the
table/field grid to the lengths of the table and field names (including
any functions applied to the fields). I am not talking about the query
results. I am talking about sizing parts of the query DESIGN view, so that
they are readable (long table and field names that get chopped off, long
criteria specifications that get chopped off, ...), and saving the sizing
so I don't have to redo it every time I open the query in DESIGN view.
I'm using MS Access 2003.

Jun 28 '06 #2

P: n/a
How do I do a "best fit"?

"[MVP] S.Clark" <st****************@FMSInc.com> wrote in message
news:ef*************@TK2MSFTNGP03.phx.gbl...
Highlight all of the columns then do a best fit on any one of them. It
doesn't save.
--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

"NowItsWhatever" <gl*****@verizon.net> wrote in message
news:pmnog.18142$Gh.12982@trnddc02...
In query DESIGN view, how do I automatically "fit" the columns in the
table/field grid to the lengths of the table and field names (including
any functions applied to the fields). I am not talking about the query
results. I am talking about sizing parts of the query DESIGN view, so
that they are readable (long table and field names that get chopped off,
long criteria specifications that get chopped off, ...), and saving the
sizing so I don't have to redo it every time I open the query in DESIGN
view. I'm using MS Access 2003.


Jun 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.