Datasheet View in a Form

Topic

New Reply

I’m still fretting with Access 2007 trying to create a form that has a data sheet view. So far every time I try the form displays the first record in the data sheet, but when advancing to the next record the first one scrolls up and out of view. I want the form to display all the records as they are bein entered. In addition I would like to permit the user to enter some information in the header area (it’s just there for the printout). So far all I have come up with is the datasheet view, but if I turn form header/footer on the datasheet view disappears and I’m back to one record at a time. Any solution to this? I could swear that back in Access 2000 days I was able to do this with a datasheet subform, but 2007 has me completely puzzled.

Reply | Quote

Replies

If you want to be able to use the form header and footer, but also have a list style form, you need to use a Tabular Form.
This is the Continuous Form option of the Default View Property

Reply | Quote

I can select the Datasheet View, but there is no properties option unless I switch to the Design View. But once switched to Design View the Properties list has no View property. I must be missing something big time here.

Reply | Quote

You cannot have a form with header data in datasheet view.
You could put a datasheet subform on a main unbound form.
In 2007 you could also look at using a split form.

If you want to have a form that appears as a tabular list but has a form header and footer then you need to make a tabular form.
See the images below.

Tabular Form Wizard

In Design

In Design view set the default view property to continuous form

This is a data view.

Reply | Quote