Refining Queries  «Prev  Next»
Lesson 5Using query field properties
ObjectiveSet Properties for Fields in Queries

Using Access Query Field Properties

Earlier in this course, you learned about working with properties on fields in tables. You can also set properties for fields specified in queries. Generally, you will do this when you create calculated fields. The reason that you will use these properties mainly for calculated fields is that fields used from record sources will usually have the properties already specified at the table level. You can see those properties in the MouseOver below.
This tab allows you to create a lookup style control
  1. This tab allows you to create a lookup style control
  2. Text placed in this property will be displayed on the Status bar when the field is entered.
  3. This formats the field as specified. You can use built-in formats as well as create your own custom ones.
  4. This can be used only on noncalculated fields. This property lets you specify how a user can enter values into the field.
  5. This lets you create a title that will be used as a label on a form or column headings.

Query Field Properties
How the query would look, with the Format property set
How the query would look, with the Format property set

Setting the Caption property for a field allows you to display a more descriptive heading than the field name.
In the next lesson, you will learn how to identify fields you can index to improve query performance.

Using Query Field Properties - Exercise

Click the Exercise link below to practice setting the Caption property for a field in a query.
Using Query Field Properties - Exercise