Results 1 to 2 of 2
  1. #1
    adublish is offline Novice
    Windows Vista Access 2003
    Join Date
    Mar 2010
    Posts
    1

    Access VBA code to calculate min and max character length of all columns in a dataset

    hi,



    need help from an access wizard. i am new to access and looking for a vba code that can calculate the min and max length of each column. the code should be generic so that even if the number of column changes it calculates the length of each column and posts it in a new table (result table) which i have created.

    your help shall be most appreciated!

    many thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You could modify these to do length instead of value:

    Minimum or Maximum Value Across Fields of Record
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2003 code vs Access 2007 Code
    By ralphjramirez in forum Access
    Replies: 5
    Last Post: 11-23-2009, 12:33 PM
  2. Line Return escape character
    By Jerry8989 in forum Access
    Replies: 8
    Last Post: 10-02-2009, 09:53 AM
  3. filter by the number of character
    By bangemd in forum Access
    Replies: 1
    Last Post: 06-30-2009, 10:33 AM
  4. Replies: 1
    Last Post: 06-01-2009, 04:05 PM
  5. Replies: 0
    Last Post: 04-29-2009, 04:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums