autofit column width in access

[Arash]

Is it possible to autofit column width in Access using vba? Something
like the following in Excel:

Worksheets("She et1").Columns(" A:I").AutoFit

Thanks in advance,

[Wayne Gillespie]

Re: autofit column width in access

On 24 Jan 2007 14:39:22 -0800, "Arash" <amahdian@gmail .comwrote:

>Is it possible to autofit column width in Access using vba? Something
>like the following in Excel:
>
>Worksheets("Sh eet1").Columns( "A:I").Auto Fit
>
>Thanks in advance,

This may help

http://www.lebans.com/autocolumnwidth.htm

Wayne Gillespie
Gosford NSW Australia

[Kevin Chambers]

Re: autofit column width in access

I've done it this with forms that are in datasheet view:
Forms("MyForm") .Controls("MyCo ntrol").ColumnW idth = -2


On Jan 24, 2:39 pm, "Arash" <amahd...@gmail .comwrote:

Is it possible to autofit column width in Access using vba? Something
like the following in Excel:
>
Worksheets("She et1").Columns(" A:I").AutoFit
>
Thanks in advance,