How to Set Column Width in Datasheet View? – Access World Forums

Re: How to Set Column Width in Datasheet View?

Hi Terry

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.

Ron

via How to Set Column Width in Datasheet View? – Access World Forums.

About Raj Bhurjee

Strong. Intense.
This entry was posted in Access Tips and tagged , , . Bookmark the permalink.

Leave a Reply