Window field properties

Window fields have the following properties:

IsEmpty

The IsEmpty property returns the value true when the value of the field is empty for the specific field type. The following table lists the empty value for standard datatypes:

Datatype

Empty value

Date

0/0/0

Currency

0

Integer

0

Long

0

String

Empty string

Time

000000 which corresponds to 12:00:00 AM

IsFilled

The IsFilled property returns the value true when the value of the field is set to the maximum value for the specific field type. The following table lists the filled value for standard datatypes:

Datatype

Filled value

Date

12/31/9999

Currency

99999999999999.99999

Integer

32,767

Long

2,147,483,647

String

The length byte (first byte) of the string is set to the storage size of the string minus 1. Each of the remaining bytes is set to string equivalent of ASCII 255.

Time

23:59:59

Value

The Value property is used to set or retrieve the value of the field. The IntelliSense in Visual Studio will tell you what type of value is used for the field.