Part IV: Professional Database Development
1088
Remove Personal Information from File Properties on Save
Checking this box automatically removes the personal information from the file properties when
you save the file. You must close and reopen the current database for this change to take effect.Use Windows-Themed Controls on Forms
Checking this box uses your system’s Windows theme on the form/report controls. This setting
only applies when you use a Windows theme other than the standard theme.Enable Layout View
The Enable Layout View check box shows or hides the Layout View button on the Access status
bar and in the shortcut menus that appear when you right-click on an object tab.Note
Remember that you can disable the Layout view for individual objects, so even when you enable this option,
Layout view may not be available for certain forms and reports.
Enable Design Changes for Tables in Datasheet View
The Enable Design Changes for Tables in Datasheet View check box allows you to make changes to
your tables in Datasheet view, as opposed to having to be in Design view. Since you won’t want
your users to make any table changes at all, this should be unchecked.Check for Truncated Number Fields
Checking this option makes numbers appear as “#####” when the column is too narrow to display
the entire value. (This behavior has been in Excel for a long time.) Unchecking this box truncates
values that are too wide to be displayed in the datasheet, which means that users see only a part of
the column’s value when the column is too narrow and might misinterpret the column’s contents.Picture Property Storage Format
Under Picture Property Storage Format, you can choose how graphic files are stored in the data-
base. Your options arel Preserve Source Image Format (Smaller File Size): Choose this option if you want to
store the image in the original format, which also reduces the database size.
l Convert All Picture Data to Bitmaps (Compatible with Access 2003 and Earlier):
Choose this option if you want to store all images as bitmaps, which increases the database
size but keeps it compatible with previous versions of Access (Access 2003 and earlier).Earlier versions of Access always stored images twice within the database. The first copy was the
original format of the image file (such as .jpg), while the second copy was a bitmap used only to
display the image on Access forms and reports. Because images were stored twice, early Access
databases were prone to severe bloating when a lot of image data was stored in the .mdb.You have the option to Preserve Source Image Format to conserve disk space by reducing the data-
base file’s size. (This option is only available in the .accdb file format.) When using this option,