Datasheet view

  • Thread starter Thread starter Alan T
  • Start date Start date
A

Alan T

I got a form has been set the format as DataSheet.
However, when it is displayed from my main form by:
DoCmd.OpenForm "frmSetup", acNormal, , , acFormEdit, acWindowNormal

It display as:

Field label, Field value text box.
 
I got a form has been set the format as DataSheet.
However, when it is displayed from my main form by:
DoCmd.OpenForm "frmSetup", acNormal, , , acFormEdit, acWindowNormal

It display as:

Field label, Field value text box.
Click to expand...

Change acNormal to acFormDS to make it appear as a datasheet. The parameter in
the OpenForm method overrides the default setting.

John W. Vinson [MVP]
 
Back
Top