When a form is in Datasheet view what is the VBA to retrieve the width of any given column. If you reference the controls collection, you get the width of the control in twips as if the form was in form view not datasheet view.

Thanks in advance,
Mike

I figured it out late last night (no help to the Help file). Does anyone else think the help file (VBA specifically) has gone down hill in the past couple of versions?

Just in case anyone is curious.

There are some properties that are specific to controls when the form is in datasheet view. (not an all inclusive list)

ColumnWidth
ColumnOrder
ColumnHidden

I'm using these to allow the user complete control over the viewing of the data in datasheet view. There is a button that lets them remember their specific layout. When the form is opened the defaults for a user are read and applied to the form.

I thought there might be a performance issue, but the form opens in a fraction of a second.

Regards,
Mike