Wednesday, May 22, 2024
HomeWindowsMicrosoft OfficeAccess 2010: Set the default format for datasheets

Access 2010: Set the default format for datasheets

If you usually use only one format for all of the datasheets in your Access 2010 databases, you can tweak the settings inside the program to make the datasheets appear in that exact format to save your time changing the formatting options each time a new datasheet is created. This tutorial will show you how.

1. Launch Access 2010.

2. Go to File -> Options.

3. In the Access Options, go to Datasheet.

4. On the right side of the Options window, there are several format options for you to tweak. You can choose to show or hide horizontal/vertical grid lines, set cell effects (Flat, Raised, Sunken), change the column width, and default font (size, weight, underline, italic).

5. Click the OK button at the end of the window to save the setting.

6. Save and close any open datasheets and open them again to see the changes.

Lê Hoàng
Lê Hoàng
When not creating exciting new Android games, Lê Hoàng is here crafting tutorials, tweaks, and fixes for your enjoyment.


Please enter your comment!
Please enter your name here

Most Popular


Recent Comments

error: Content is protected !!