The Allow Datasheet View property on the form must be set to Yes for this view to be
available.
Datasheet views are often used in subforms where the user browses through a set of main
records and can then view the detail relating to an individual record.Making Your Form Look Professional
You can make your form look cleaner by removing the record selector bar on the left-hand
side of the form but keeping the navigation buttons at the bottom of the form. You do this by
setting the Record Selector property on the form to No, but keeping the Navigation Button
property set to Yes. Make sure the Selection type is Form before looking for the Record
Selector. It is easy for the focus to jump to another object.
You will also find that it is quite difficult when dragging and sizing controls on the form to
get the alignment and size uniform. Frequently, you end up with two text boxes, one of them
slightly taller than the other.
Although this is very much cosmetic, users tend to home in on this kind of thing, and they
expect all controls to be nicely aligned and uniformly sized! Fortunately, Microsoft provided
some tools to help you with this.106 Microsoft Access 2010 VBA Macro Programming
Figure 9-5 Datasheet View of the form