Access Datasheet View: How To Apply Formatting

Access Datasheet View – Formatting Options

Take a look at the following two and half minute video tutorial on how you apply formatting to your Access datasheet view in your tables; the back-end area of your Acess database file.

Access Datasheet View – My Comments

In the video, it quickly showed you how to change the column widths and row heights plus setting the newer feature (versions 2007 and 2010 only) of applying the alternate row colours too.

This was all covered via the main dialog box which is called from the ‘Home’ tab on the Ribbon bar where multiple attributes can be set in one go for your Access datasheet view.access datasheet viewYou can not set any conditional formatting options as with forms and reports as it applies to the background datasheet view and not the actual value in a field.

Notice how the row height (for a record) is applied to all records as there is no concept of separate rows in this view; just an index for each record which makes this very different from say an Excel spreadsheet.

One final thing to remember is that any changes made which also extends to sorting and basic filtering too is that you will be prompted to save your changes as this is a structural ‘document’ change and not to be confused with the auto-save action for any data changes in your Access datasheet view.

Take a look at my eBook offer on how to build and Access database which includes the general feature of this database application.

This entry was posted in Microsoft Training, MS Access, Tables and tagged , , , , . Bookmark the permalink.

One Response to Access Datasheet View: How To Apply Formatting

  1. Ben Beitler says:

    As a useful tip! I hide columns in a table if this is going to serve as the back-end to my database with no intention for users to work in this view as an added protected layer to gaining access to the back-end if not locked out in the first instance.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.