Change the gridline style and background color in Datasheet view

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

Notes  

• Changing the format of a specific datasheet overrides the default datasheet format defined in the Datasheet tab of the Options dialog box on the Tools menu.
  
  
• You can't save datasheet formatting changes to a datasheet in a Microsoft Access project unless it is a form. If you need to save formatting changes to an Access project table, view, or stored procedure datasheet, use the AutoForm Wizard to create the datasheet as a form (which quickly sets the RecordSource property to the datasheet and adds all the fields to the form), and then set the form's DefaultView and ViewsAllowed properties to Datasheet (which makes the form behave like a datasheet).