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
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Learn how to number pages in an Access report over each group.
Activate two pass printing by referencing the pages property:
Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: