Empty property


The Empty property specifies whether a field contains a value.


field.Empty [= boolean]


field – A window field object.

boolean – If True, the field is empty. If False, the field contains a non-zero value.


To clear a field’s value, set the field’s Empty property to True. You cannot clear a field that the accounting system locked or disabled, but you can clear fields you’ve locked or disabled using VBA.

VBA considers numeric fields empty if they contain a value of 0. String fields are empty if they contain nothing or only spaces. Date fields are empty when the date is 00/00/00. Time fields are empty when the time is 12:00:00 AM.

Documentation Feedback