Databases Reference
In-Depth Information
On the
General
tab, the following properties are of interest:
•
Title
: This property can be used to set the title that appears in the tab row.
In addition to static text, this can also be a calculated value.
•
Show Sheet
: This property can be used to conditionally hide/show the sheet.
For example, we can use an expression like
GetSelectedCount([Carrier
Name]) = 1
to only show the sheet when a single carrier is selected.
•
Sheet ID
: This property is the internal ID of the sheet. This ID can be used
to reference the sheet from other objects in the document, for example, to
activate the sheet by clicking on a button object.
•
Background
: We can either use the
Document Default
option, which we
set in the previous section, or override the default by setting a sheet-specific
Color
and/or
Image
selection.
•
Tab Settings
: This property can be used to set any desired
Tab Color
or style.
We've previously worked with the
Fields
tab, which is an easy way to add multiple
listboxes to the sheet. Simply select the required fields from the
Available Fields
listbox
and double-click (or click
Add >
) to include them in
Fields Displayed in Listboxes
.
The
Objects
tab shows all of the objects that are present on the worksheet, even those
that are conditionally hidden. From this tab, we can directly open the individual
object's
Properties…
dialog or even
Delete
any of them. The
Objects
tab is shown in
the following screenshot: