Build Field dialog box

Allows you to select a database field or to build a complex field for a linked database. A complex field is a combination of one or more database fields and possibly other text. For example, Name: + {-First_Name+ +Last_Name-} is an example of a complex field that would display "Name:" followed by the full name.

Field Name

Select the first field you want to display.

Number Format

Select or specify the number format if the selected field is a number and you would like to format it a specific way. Leaving this field blank will display the field as it is stored in the database. See the format examples shown in the dialog box.

Add Field button

Click this to add the selected field to the Construct Field.

Other Text

Enter any other text you want to add.

Add Text button

Click this to add the Other Text to the Constructed Field.

Add Space button

Click this to add a space to the Constructed Field.

Add New Line button

Click this to add a new line to the Constructed Field.

Constructed Field

Displays the Constructed Field.

Standard Address button

Click this to use a standard address definition for the Constructed Field.

Note:

•	This works when linking to the Names and Addresses Personal Database. For other databases with different field names you will have to change the field names so they match the field names in your database.