If you format a field that requires a value, Access will not accept the data if the field is left blank (null).