Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Oct 2007
    Location
    Ely, Cambridgeshire, United Kingdom
    Posts
    37
    Thanks
    0
    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •