Data cells in ad hoc grids may contain missing data or data that you do not have permission to view. In such cells, ad hoc by default displays #MISSING or #NoAccess, but you can change these labels.
| Option | Description |
|---|---|
| #MISSING/#NoData | Replaces, in data cells missing data, a user-defined option. The default value is #MISSING. |
| #NoAccess | Replaces, in data cells in which you do not have access permissions, a user-defined option. The default value is #NoAccess. |
| Submit Zeros | If selected, specifies a zero (0) as a replacement value instead of #MISSING. Note: This occurs only for cells in which you manually changed the value to #MISSING. |