BUG: Cell Data Disappears in DBGrid with NumberFormat Set

• Standard, Professional, and Enterprise Editions of Microsoft Visual Basic, 16-bit and 32-bit, for Windows, version 4.0

SYMPTOMS

Setting the NumberFormat property for a column in a DBGrid control to

'general number' or 'fixed' sometimes causes all cell data to disappear.

RESOLUTION

At design time, right-click the DBGrid control, and click Retrieve Fields to set the column headers automatically to information from the bound data control. Then reset any NumberFormat properties you have modified.

This will fix the problem permanently for this DBGrid control. However, you can't use this solution if the DatabaseName and RecordSource properties of the data control are not known until run time. In this case, set the NumberFormat property of each relevant column in code. This can be done immediately after the data control is connected to the database by using code similar to this:

   Data1.DatabaseName = "C:\Access\Number.mdb"
   Data1.RecordSource = "Numbers"
   Data1.Refresh
   DBGrid.Columns(0).NumberFormat = "fixed"

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

1. In Microsoft Access, Data Manager, or VisData, create a new database that has one table consisting of two Number fields. Fill in a few of the records with random numbers.

2. Start a new project in Visual Basic. Form1 is created by default.

3. Double-click the Data Control button in the Toolbox to create a new data control (Data1).

4. Click the DBGrid button in the Toolbox and drag a DBGrid control (DBGrid1) onto the form.

5. Set the DatabaseName property of the Data1 control to the database you created in Step 1. Also set the RecordSource property to the name of the table in your database.

6. Set the DataSource property of the DBGrid control to Data1.

7. Right-click the DBGrid control to bring up the Properties dialog box. Click the Columns tab, and select either of the columns. Change NumberFormat to fixed.

8. On the Run menu, click start (ALT, R, S), or press the F5 key. The DBGrid control will size itself correctly, but no data will appear. If you stop the program, right-click DBGrid1, click Retrieve Fields, set the NumberFormat property to fixed, and restart the program, the problem will be solved.