Results 1 to 2 of 2
  1. 04-10-2012, 11:19 AM #1
    mrbabji
    mrbabji is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    12

    Auto adjust column width in data sheet view of a form

    Hi





    I have a form in data sheet view. I want to set the form property to auto adjust the column width based on the data on the form.


    Please help.
    Reply With Quote Reply With Quote
  2. 04-10-2012, 12:34 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Doesn't work in Datasheet view, could do in Continuous view. Setting width based on data length only practical if using non-proportional font, such as Courier
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    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 adjust column width in a subreport?
    By nevets in forum Reports
    Replies: 2
    Last Post: 02-22-2012, 05:10 PM
  2. How to set the “Default Column width” to be in Metric units?
    By jamal numan in forum Access
    Replies: 1
    Last Post: 11-02-2011, 02:18 PM
  3. Auto adjust table data
    By hawzmolly in forum Access
    Replies: 3
    Last Post: 10-23-2011, 05:53 AM
  4. Data sheet sub-form
    By cb19366 in forum Forms
    Replies: 1
    Last Post: 03-31-2010, 01:05 AM
  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