Re-Post-Datasheet View Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...

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
 
Back
Top