Re-Post-Datasheet View Question

[Guest]

I have a challenge, each time I build a form for it be in 'datasheet' view it
continues to pop back up a different format and won't stay in datasheet view.
I have tried to changes the views in the properties to Datasheet but it
still returns to columnar. Can someone explain how to keep the format and
make it come up that way all the time.
Thanks,
IEJ

 

[Joan Wild]

I have a challenge, each time I build a form for it be in 'datasheet'
view it continues to pop back up a different format and won't stay in
datasheet view. I have tried to changes the views in the properties
to Datasheet but it still returns to columnar. Can someone explain
how to keep the format and make it come up that way all the time.

Change the default view to datasheet, and also the 'views allowed' to
datasheet.

It is also possible that if you are opening the form in code i.e.
DoCmd.OpenForm "MyForm"
you need to specify the form view i.e.
DoCmd.OpenForm "MyForm", acFormDS