Well other than the curiousity question of why would
you want to? You are going to be dealing with the
Table Definition Object. I am pretty sure you can get
access to it from VBA but I'm not 100% sure (I'm
mostly a VB programming that uses Access). If it
works like I remember you can gain access to each
element of a table (thus the fields) without needing
to know the name of the field. However you will most
likely need to do it in two steps --- 1) Find out the
width 2) Then resize the field. Hope that helps.
--- Rocky Epp <[EMAIL PROTECTED]> wrote:
> Here is my problem, can anyone point me in the right
direction
> of how to accomplish this? I'm a
novice-intermediate VBA
> user. I want to write a function that will look at
a table in
> access and resize each field to the length of the
longest data
> in each field. Also, the table may have a different
number of
> fields each time and different field names.
>
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
