Unanswered: Simple question: how to set Column width in datasheet?
Hi, I have a form with subforms in datasheet view, I noticed that fields are too wide, I've tried to adjust it manually in design view but didn't work, and in layout view, and even in form view, but it fits temporarily and resets to the previous width after I close the form or change to design view.
but, just can't find the column width property,, i can only see it with combo box fields, but not in text box fields. Where can I find it? and if it is not possible to find it in property sheet, how can I do that in code?
I saw an example in the net and accordingly I wrote a code to set a field called 'cost' in a subform called tblBill Subformbut it didn't work
I put this code in the main form load event (so not in the subform) ..
Forms![tblBill Subform]![Cost].ColumnWidth = -2
I would place it in the Form_Load event handler. In Form_Current it will be executed repeatedly, as the Current event is triggered every time you select another record, which for a form in datasheet view occurs every time you select another row.