set the widths of columns in an Access table

[Bill-41]

Is there an equivalent function for this Excel code to use in Access to ...

Columns("F:H").EntireColumn.AutoFit

to autofit the columns of an Access table?

Thanks!

 

[Dirk Goldgar]

Is there an equivalent function for this Excel code to use in Access to
...

Columns("F:H").EntireColumn.AutoFit

to autofit the columns of an Access table?

Stephen Lebans has worked out a solution for forms in datasheet view. See
this link:

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

 

[Douglas J. Steele]

Stephen Lebans has worked out a solution for forms in datasheet view. See
this link:

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

Note that this solution assumes you're using a form. Your users should never
be working directly with tables: you should always provide them with forms.

 

[Bill-41]

Thanks for the advice but I'm just looking at the table for my own use ....
just wanted to be able to narrow the columns so I can see more in the same
space. Is it possible?

Thanks, Bill

 

[Douglas J. Steele]

I don't believe there's any way to interact with table column widths
programmatically.