|
- icon link
- A small icon that links to
another document. Used in a document instead of embedding or
linking
- identifier
- The part of an expression that refers to an object's value or
property. Depending on where and how you are using the expression,
the identifier may need parts.
Examples:
[Price]+[Shipping] uses the simple identifiers [Price] and
[Shipping] to refer to a field in the current table.
Scores.AssignmentID > 67 uses the full identifier for the AssignmentID
field that is in the Scores table.
Reports![Grades]![StudentName].Visible is the full identifier for
the Visible property of the control StudentName that is in the
report named Grades.
- IIf function
- The Immediate IF function is an conditional function,
providing two different values, depending on whether an expression
is True or False.
Syntax: IIf(expr, truepart, falsepart)
where expr is an expression that can be said to be
either True or False, truepart is the value you want to see
when the expression is true, falsepart is what you want to
see when the expression is false.
Both the truepart and falsepart are evaluated. Be
careful that they won't generate an error, like trying to divide
by zero.
Examples:
IIf([Balance] > 0, "You owe "& [Balance], "Paid")
- Image control
- A control on a form or report that contains an image. This is
different from inserting an image as an OLE object in an unbound
OLE frame.
- import
- Bringing data or objects into a database from outside the
database.
- index
- A feature of a database that puts the key fields in a table
into order. Sorting and filtering can be much faster using an
index, rather than having to work with the original table and all
its other data.
- Input Mask Property
- A field in a table has this property. An Input Mask controls
what you see as you enter and edit data in the
field. It is a different property from the Format property, which
controls how values are display after they are saved.
Examples and syntax
|