Thread: Field sizes in tables (2002)
2008-05-29, 15:54 #1
- Join Date
- Oct 2007
- Ely, Cambridgeshire, United Kingdom
- Thanked 0 Times in 0 Posts
Field sizes in tables (2002)
How can I get a table of data (that I have made from a make table query), to have the columns auto fit to the size of the column heading or longest data in that column? Thanks.
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2008-05-29, 16:49 #2
- Join Date
- Mar 2002
- Thanked 16 Times in 16 Posts
Re: Field sizes in tables (2002)
Access isn't really good at that. You can select one or more columns, then select Format | Column Width... and click Best Fit. But it will apply only to the currently visible records. There is no way to make it work for *all* records, and there is no way to have Access do it automatically.
But this shouldn't be a problem, since end users should never work with tables or queries directly, but use forms instead.