Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Logical functions > IsEmpty function |
|
|
| IsEmpty function |
| Format |
IsEmpty(field) |
| Parameter |
| field - any field name, text expression, or numeric expression |
| Data type returned |
| number |
| Description |
| Returns True(1) if field is empty, if a related field, related table, relationship, or file is missing, or if some other error occurs; otherwise returns False(0). |
| Examples |
| IsEmpty(OrderNum) returns 1 if the OrderNum field is empty. |
| If(IsEmpty(LastName);"Invalid record";"") displays Invalid Record if the LastName field is blank, but displays nothing if there is an entry in LastName. |
| IsEmpty(Payments::DatePaid) returns 1 if, for example, the Payments table has been moved or renamed. |
| IsEmpty("text") returns 0. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Logical functions > IsEmpty function |
|
|
Next Page |
|