Results 1 to 5 of 5
  1. 03-01-2020, 01:06 PM #1
    Sarge, USMC
    Sarge, USMC is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2010
    Posts
    43

    Table data & column width


    Is there a way to apply a "best fit" parameter to all columns in a table in Access 16?

    I can do 1 column at a time. Don't want that.
    Reply With Quote Reply With Quote
  2. 03-01-2020, 01:16 PM #2
    orange's Avatar
    orange
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    ??? Can you give an example of what you expect???
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
  3. 03-01-2020, 01:19 PM #3
    Sarge, USMC
    Sarge, USMC is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2010
    Posts
    43
    Actually, I found it. "Records...More...Field Width...Best Fit."

    Let's talk about a query now. Is there a way to center the data across all columns in a query table? The text formatting button is greyed out.
    Reply With Quote Reply With Quote
  4. 03-01-2020, 01:32 PM #4
    Sarge, USMC
    Sarge, USMC is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2010
    Posts
    43
    Or...moderator. Close this thread and I'll open another one for that topic.
    Reply With Quote Reply With Quote
  5. 03-01-2020, 01:35 PM #5
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Quote Originally Posted by Sarge, USMC View Post
    Actually, I found it. "Records...More...Field Width...Best Fit."

    Let's talk about a query now. Is there a way to center the data across all columns in a query table? The text formatting button is greyed out.
    IMHO that kind of thing is best done with a form that is bound to your query.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. How do I export an Access Table to a non-delimited flat file with pre-defined column width?
    By a6asics in forum Programming
    Replies: 7
    Last Post: 09-27-2018, 01:08 PM
  2. Autosize a column's width and height?
    By Isla in forum Reports
    Replies: 1
    Last Post: 04-05-2016, 01:58 PM
  3. Column width in subform needs to match label's width
    By newbieX in forum Forms
    Replies: 3
    Last Post: 04-10-2015, 02:35 PM
  4. Auto adjust column width in data sheet view of a form
    By mrbabji in forum Forms
    Replies: 1
    Last Post: 04-10-2012, 12:34 PM
  5. How to Fix the Column width in datasheet in a Form
    By wongray in forum Forms
    Replies: 0
    Last Post: 12-25-2008, 10:05 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums