Re: How to Set Column Width in Datasheet View?
I hope you have found your solution but just in case you haven’t….
This works for me in Access 2010
Add the following to the form_open code for my sub form for each field:
me.<fieldName>.ColumnWidth = -2
Thanks to the post from jleval
The fieldname I used is the text box name, for my db this is different to the actual field name in the table.
It’s a bit cumbersome to repeat the line for each field but it works.
Could probably put in a loop but there are not so many fields in my sub form.