The word “format” can mean multiple things in Access. The links in the tables below can help you find the information that you need, based on which tasks that you are trying to perform.
What do you want to do?
Format text, dates, or numbers
Use expressions and property settings to make sure that data displays the way that you want. The articles in this section apply to multiple versions of Access.
| Description |
Link |
| Learn the basic syntax of the Format function and see some examples of how to use it in an expression (expression: Any combination of mathematical or logical operators, constants, functions, and names of fields, controls, and properties that evaluates to a single value. Expressions can perform calculations, manipulate characters, or test data.). |
Format Function |
| See specific examples of how to format dates and times by using the Format function in an expression. |
Format date and time values |
| Learn how to set the Format property to control the display of dates and times on forms, reports, and datasheets. |
Format Property - Date/Time Data Type |
| Learn how dates and times are displayed in Access, how to add a Date/Time field to a table, and how to make sure dates and times are entered and displayed the way that you want. |
Format the date and time field in Access |
| Display data in a specific format, even if it’s stored with a different format. |
Specify how data displays by using custom formatting |
| Use the Format function to answer questions such as, “which week of the year is this?” or “which day of the year is this?” |
Calculate the serial number of the day, week, or month in a date |
| Get general information about how to add and format date/time fields. |
Add and customize date and time formats |
| Customize the default settings for datasheets, such as gridlines, raised or sunken cell effects, and font styles. |
Set the default format options for datasheets |
Top of Page
Highlight important data on forms and reports
Apply conditional formatting rules to make important data easier to see.
Top of Page
Improve the appearance of database objects
Create a more professional-looking application by using Office Themes, images, and layout features.
Top of Page
Make sure data is entered in the correct format
Learn how to use input masks and validation rules so that data is formatted correctly at the point of entry.
Top of Page
Learn about file formats
Learn how to save databases in earlier file formats, or upgrade older databases to the newer format.
Top of Page
