Access Database - Unable to force a datasheet form to have a fixed width for text box.
Posted on 2007-11-23
I have a form. On this form there is a subform. On this subform there is another form that is a datasheet.
My problem is this: How can I force the width of the text box on this datasheet to be a certain size without code and the accompaning overhead. Basically the user can fiddle until the column width is 0 thus the field will no longer show.
I coded a Current Event (see below) but it seems this is a lot of everhead. BTW - this is an unbound .adp against a SQL Server - so I am looking for the least overhead possible since this thing is getting hit by 250 users.
Private Sub Form_Current()
Forms!frmMain.frmA.Form.Controls(0).ColumnWidth = 500
Forms!frmMain.frmA.Form.Controls(1).ColumnWidth = 2000