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.You 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.