Database Reference
In-Depth Information
Previous Navigation Block : Sets the block to which the cursor moves if a
user presses Shift + Tab from the first field in the current block. Type a
block name.
Query Allowed : Determines whether a user can query fields in the
block—search for records with a field set to a value that matches a
search value. Select TRUE or FALSE .
Query Data Source Name : Sets the database table or view searched for
records in response to a query. Type the name of a database table or view.
Field attributes
You can set the following field attributes:
Background Color : Sets the color of space surrounding field entries. (For a
field instance in a selected row, the Current Row Background Color setting
for the block takes precedence.) Select from six colors.
Conceal Data : Presents asterisks rather than actual entries for a field. Enter
the value as TRUE and in order to set the value to FALSE , do not select
this attribute.
Font Size : Sets the type size for field entries. (For a field instance in a selected
row, the Current Row Font Size setting for the block takes precedence).
Select a number from 1 to 18 points.
Font Weight : Sets the thickness of type for field entries. (For a field instance
in a selected row, the Current Row Font Weight setting for the block takes
precedence.) Select from nine weights.
Foreground Color : Sets the color of field entries. For a field instance in a
selected row, the Current Row Foreground Color setting for the block takes
precedence.) Select from six colors.
Format Mask : Imposes formatting on numeric or date fields:
° 999"-"99"-"999 : Social Security Number
° $999,999,999.99 : Monetary value, US currency up to $1 billion
° 999,999,999.9999 : Numeric with thousand separators, up to
four decimals
° 999,999,999.99 : Numeric with thousand separators, up to
two decimals
° L99G999D99 : Local currency with thousand separators, up to
two decimals
 
Search WWH ::




Custom Search