Set defaults for the appearance of Datasheet view

1. Open a table, query, form, view, or stored procedure in Datasheet view.
   
   
2. Click Options on the Tools menu.
   
   
3. Click the Datasheet tab.
   
   
4. Click the options you want.

Note   These options do not override any changes you have previously made to specific datasheets using the Format menu commands. If you want those specific datasheets to also have the same format, you must make the changes in the specific datasheets using the Format menu commands or remove the saved properties using Visual Basic code.