For more information about Access training, please call (512) 794-8440 or please fill out our Pricing Request Form and we will contact you with more information.
Mention this ad on your registration
When you use the Number data type for a field in a table, Access automatically assigns zero ( 0 ) to the field’s Default Value property. But what if you would like your table to display a blank cell rather than a zero if the number field is left empty?
Try the following:
- Open the table in Design view and select the field with the number data type.
- Select the Default Value property for the number field.
- Change the Default Value property from 0 to Null.
- Save the table.