Datasheet view

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

 

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

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]

 

[Guest]

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