Report Expression Dialog Box

Defines the contents of a field control in a report. This dialog box appears when you place a field control on a report or label.

• Expression
  Displays the currently selected expression, such as a table field or variable, or makes it possible for you to type a new one. Choose the dialog button to display the Expression Builder dialog box if you want to create an expression and verify it before continuing.

• Format
  When a valid expression is displayed in the Expression box, you can specify a format in this text box. Choose the dialog button to display the Format (Field) dialog box if you want to specify the format for the field in your report.

• Calculations
  Displays the Calculate Field dialog box so you can select an expression to create a computed field.

  Note   SUM and COUNT commands do not function within report expressions.

• Print When
  Displays the Print When dialog box so that you can specify the conditions that must be met before the text is printed in your report or label.

Object Position

• Float
  Specifies that the selected field move relative to the size of the surrounding fields.
• Fix Relative to Top of Band
  Causes the field to remain in the position you give it in the Report or Label Designer and maintain that position relative to the top of the band.
• Fix Relative to Bottom of Band
  Causes the field to remain in the position you give it in the Report or Label Designer and maintain that position relative to the bottom of the band.
• Stretch With Overflow
  Causes the field to expand down the report page to display all data in the field or expression.
• Comment
  Makes it possible for you to add comments to the .frx or .lbx file. Comments are for reference only and do not appear anywhere in the printed report or label.

See Also

Calculate Field Dialog Box | Expression Builder Dialog Box | Format (Field) Dialog Box | Print When Dialog Box | Report Designer | Quick Report Dialog Box | Adding Reports and Labels