Formatting A Datasheet

In this blog post we show you how to format a datasheet in MS Access.

Although, generally, datasheets are boring grey forms that we can use to sort and filter data, we can actually format them to make their appearance more appealing. Open up a form in datasheet view.

Background Colour and Alternate Rows

Click on the icon inside the red circle to bring up the Datasheet Formatting dialog box  Datasheet Formatting Dialog Box
Using this dialog box you can:

  • Change the background color.
  • Change the alternate background color.
  • Change the cell effect.
  • Choose whether to display gridlines.
  • Choose the gridline colors.
 Formatted Datasheet

These options can make datasheets look more pleasing (although we accept the one above is not to everyone’s taste). If you are developing for a company you can use row colors to match their company logos (definite extra bonus points)!

Feel free to change the appearance of datasheets and make your applications more interesting.

Related Posts

Adding A Record In Datasheet View
Deleting A Record In Datasheet View
Hyperlinking To A Form
Sorting and Filtering A Record In Datasheet View

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!