The information in this article applies to:
- Standard, Professional, and Enterprise Editions of Microsoft Visual
Basic, 16-bit and 32-bit, for Windows, version 4.0
SYMPTOMS
When you set the NumberFormat Property through the Property page of the
DBGrid control, it does not affect the column displayed in the control.
STATUS
Microsoft has confirmed this to be an issue in the Microsoft products
listed at the beginning of this article. Microsoft is researching this
issue and will post new information here in the Microsoft Knowledge Base
as it becomes available.
MORE INFORMATION
Steps to Reproduce Behavior
- Start 16-bit or 32-bit Visual Basic 4.0, or if it is already running,
click New Project on the File menu.
- Add a data control and a DBGrid Control to the Form1 form. Set the
controls to the following properties:
Control Default Name Property Setting
---------------------------------------------------------------
Data Data1 DatabaseName Biblio.mdb
RecordSource Titles
DBGrid DBGrid1 DataSource Data1
- Right-click the DBGrid control and click Retrieve Fields. Note that the
column headers are now set to field names from the Titles table.
- Right-click the DBGrid control and click Properties to open the
Properties page. Click the Columns Tab and choose Column1 (Year
Published) in the Column list box. In the Number Format Combo box, enter
##. The "Year Published" field is of type Integer in the database. Click
OK to close the Properties page.
- On the Run menu, click Start or press the F5 key to start the program.
The Year Published column still appears with four instead of two digits.
|