Datasheet view

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.
 
J

John W. Vinson

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]
 
D

deepinlife

acNormal means form view..it is teh defulat view in the method.
so u have to override it
 
Top