View Field Properties Dialog Box
Use to specify options for fields in a view just as you can for fields in database tables. You can define properties to determine the type of data the field stores, to control data entry for updatable views, and to control the display of the field.
This dialog box appears when you select a field and click the Properties button on the Fields tab of the Query and View Designers.
- Field
Specifies the name of the selected field in the view. To set properties on other selected fields, you can choose from the drop-down list. The field appears with its sequential field number.
Field Validation Options
These options allow you to control the contents of the field.
Rule
Specifies the expression for the field-level rule that controls which values can be entered into the field.Message
Specifies the error message displayed when the field-level rule is violated.Default value
Specifies a quantity or string that is the content for a field when a new record is added. The default value remains in the field until you enter a new value.
Display Options
These options allow you to control how values are entered or displayed in the field.
Format
Specifies the expression for case, size, and style for display of the field in the Browse window, forms, or reports. Property settings within the form and report can override this expression.Input Mask
Specifies the format for values as they are entered into the field. For example, telephone numbers might have a format of (999) 999-9999.Caption
Specifies the label that appears for the field in the Browse window, forms, or reports. Property settings within the form or report can override this setting. To specify an expression for a field caption, include the equal sign (=) preceding the caption string. If an equal sign is not found, it is treated as a string literal. Expressions cannot exceed 254 characters. If the expression exceeds 254 characters, the caption defaults to the field name.Note
Support for using expressions as field captions should be used only with DBC tables in applications running on Visual FoxPro 8.0 or later. In earlier versions, the expression appears as a string literal.
Map Field Type to Classes Options
If you plan to use the view field in forms, these options allow you to specify a default control type that appears when you drop the field on a form.
Display library
Specifies the class library file (.vcx) containing the control class you want to associate with the field.Display class
Specifies the type of control that is created when the field is dropped onto a form.
Data Mapping Options
By default, the view field has the same property settings as its associated field in a table. These options are only enabled for remote views.
Data type (remote views only)
Specifies the kind of data this field can hold.Width (remote views only)
Specifies the number of characters this field can hold.Decimal (remote views only)
For numeric data types, specifies the number of places to the right of the decimal point this field can hold.Comment (remote views only)
Provides space for you to type a comment about the field.
See Also
Tasks
How to: Create Default Values for View Fields
Reference
Join Tab, Query and View Designers