ACC: Null Value Does Not Pass Validation Rule

MORE INFORMATION

Steps to Reproduce Behavior

1. Create the following new table and save it as Table1:
   

         Table: Table1
         ---------------------------------------------------
         Field Name: ID
            Data Type: AutoNumber (or Counter in version 2.0)
         Field Name: Code
            Data Type: Text
            Validation Rule: "A" Or "B" Or Is Null
   						

2. View the table in Datasheet view.
3. Select the Code field. Type A and press ENTER. Note that you can move to the next record.
4. In the next record, press TAB to move to the third record. Note that you cannot move to the next record because the Code field cannot initially be Null. This is because there is only one user input field defined in this table, and the record cannot be saved until it has received some input.
5. Select the Code field in the second record. Type A and press ENTER. Delete the A from the field, and press TAB. Note that you can move to the next record now because the record was initially saved with data.