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.
Subscribe to our Windows Secrets Newsletter - It's Free!
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.