Changing Field Properties

Professional Version Only


Table of Contents   Previous Page  Next Page    

The Field Properties window is available for any field on a user-defined report, label, or view.  The properties vary by type of report/view, as described below.

The following fields are available:

Name: The name may be changed for your own reference, even if it doesn't appear on the report (such as for a mailing label).

Hide Data - Select this option to hide the entire field. This is helpful if you only want to use the field as a primary or secondary sort, but don't want to actually see it. For example, suppose you use the combined First Name/Last Name smart field on the report, but want to sort on the last name only. Since the combined field shows the first name first you can't sort on the last name portion; instead, add the last name field and mark it as the primary sort, and then make it hidden to solve the problem.

Hide Heading: If you want to see the field, but want the heading left blank, select this option. This field is not available to mailing labels or other report that don't have column headings.

Sort: Choose a Primary and an optional Secondary sort. It is important to at least choose a field for the Primary Sort. If no sort is chosen, the records will be returned in the order they are found in the database, which may not be the way you want to see them.

Bold: Select this option to display bold text.

Italic: Select this option to display italic text.

Underline: Select this option to display underlined text.

Font: Choose a specific font face and height for this field, or select "Use Default" to take the default font settings  from the Define Fields tab.

Font Color: Defines the color used for the field data.

Back Color: Defines the color used for the field background. This option is not available to Views.

Case: Choose whether data should be forced to appear in uppercase, lowercase, or "any" case (i.e., as entered in the database).

Alignment: Choose the alignment setting for data in the field.

Calculate: For numeric data fields, you can choose to produce a total or average of the column in the summary area of the report. This option only applies to standard columnar reports, not to labels or directories.

PreText: Text entered here will be displayed to the left of the data for this field (you can leave leading or trailing spaces in this field). Tip: If you want to force a blank line to appear above a particular line (for a Roster style report), enter "~r~n" (without the quotes) in the pretext field. This code means "carriage return/line feed" and will cause a blank line to be produced before the data of the field. (This field is not available to Views.)

PostText: Text entered here will be displayed to the right of the data for this field (you can leave leading or trailing spaces in this field). This field is not available to Views.

PreText and PostText are designed to be used however you choose. One possibility is to use PreText in place of the column heading. In other words, if the column's "Hide Heading" checkbox is checked, no heading will appear. Instead, you could use PreText to show the same "heading" in front of each field to display. For example, a telephone entry on one line might show, "Tel: 123-456-7890" by using a pretext value of. "Tel:".