ACC97: Single with Currency Format Displays as Double When Edited

WORKAROUND

   $#,##0.00;($#,##0.00);$0.00
				

1. Open any database in Microsoft Access 97.
2. Create the following table and save it as tblSingle:
   

          tblSingle
          ----------------------
          Field Name: TestSingle
             Data Type: Number
             Field Size: Single
   						

3. Open the table in Datasheet view and enter the following three records:
   

          TestSingle
          ----------
           .15
          1.23
           .02
   						

   
   Close the tblSingle table.
4. In the Database Window, click the tblSingle table if it is not already selected.
5. On the Insert menu, click AutoForm.
6. On the View menu, click Design View.
7. Select the TestSingle text box. On the View menu, click Properties.
8. Click the Format tab and set the Format property to the following:
   

          $#,##0.00;($#,##0.00);$0.00
   						

9. Save the form as frmSingle.
10. Open the frmSingle form in Form view, and edit the data in the TestSingle field. Note that during the editing process, the data in the TestSingle field appears as a number of data type Single instead of a number of data type Double.