I have a form with a subform. I want the subform to appear in Datasheet View, which it does when I open the main form to enter data. However...

The subform appears in Form View when I open it directly or open the main form in Design View. This is problematic because I can't set certain properties of the subform when it is in Form View that only apply to Datasheet view (such as resizing columns).

Here's what I've tried...

-Changed the view and saved the subform.
-Set the subform to Yes for Datasheet view and No for every other view.
-Set the subform's default view to Datasheet.

I've tried all that from both the main form and the directly from the database window.

Any help would be appreciated.

Thanks,
David