Rezise Datasheet columns 1

[clapper62]

Hello All,
I have a form that opens in datasheet view.
Whenever I double click on the line between 2 columns
it will automatically adjust the width of the column.
Is there any way through code to simulate this
when the form loads so that all of my
columns are resized to the right width.

Thanks

 

[PHV]

Forms![yourForm]![yourTextBox].ColumnWidth = -2

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[clapper62]

Thanks PHV
Works great.