Writing #MISSING Values

#MISSING in a cell indicates that the cell contains no data, whereas zero in a cell is a data value. #MISSING decreases the database size and improves performance.

To write #MISSING to cells:

1. Select the cells to change.

   You can select contiguous cells by clicking in the upper-left cell in the range, and then pressing Shift+Click to select the lower-right cell in the range. You can select rows and columns by clicking row and column headings. Select a range of rows or columns by using Shift+Click.

   If the designer sets a form to suppress missing data, and an entire row contains #MISSING (no data), that row doesn't display on the form.

2. Take an action:

   • Press Delete.

   • Enter #missing.

   You can also enter #MISSING using Smart Lists.

3. Click Save.

   The cells are set to #MISSING when you save the form.