Saving column width in a subform

[cebrower]

I have a form with two subforms. See the attached screen shot. I just added the one on the right. I want to reduce the width of two columns in the new subform so that some of the fields that are farther to the right will be visible. I can change the widths manually, but when I close and reopen the main forms the field widths have not been retained. I have many other form with subforms where such changes are retained. Not sure why this subform is any different. Any help would be appreciated.

[ranman256]

you can autofit with:
fsubSorm.Form.txtBox1.ColumnWidth = -2

[Micron]

For the most part, column width depends on the largest width of data in a given view of the records. In a table or datasheet view, double click the column separator and you'll get the width needed for that view. Scroll down and you may find a record where the data exceeds the width that was just set. Double click separator again and the column will get wider. AFAIK when your form opens the widths will be governed by the width of the data in the view even if you use the suggested setting. If you want to make it static, you can use the column width property in the form load event. I believe the value needs to be in Twips (appx. 1440 per inch).
EDIT - I believe you can also set the column width in form view and save the form and it will re-open with those settings. However, this won't prevent anyone from altering the widths and saving, so a code solution is probably the only way to make it permanent.

[davegri]

You can also adjust datasheet field widths like this:

[cebrower]

Thanks Micron. Using the ColumnWidth property works perfectly for this situation.

[Micron]

You're welcome.