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