XL7: #NUM! Error Value Displayed in Microsoft Access Form
PSS ID Number: 140623
Article Last Modified on 2/14/2002
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0
This article was previously published under Q140623
SUMMARY
When you create a Microsoft Access form with a Microsoft Excel table, the
#NUM! error value may be displayed in some fields on the Microsoft Access
form.
MORE INFORMATION
When you create a data entry form by using the Microsoft Access form option
on the Data menu in Microsoft Excel, Microsoft Access sets the data type by
referring to the first record in the table; any invalid data type will
return a #NUM! error value.
RESOLUTION
Before you create the form, you must change the first record in the data
form to a Text entry. Microsoft Access then treats the field as text and
allows both text and numeric entries.
NOTE: You will not be able to modify the properties of an existing linked
table in Microsoft Access because those properties cannot be changed.
REFERENCES
For More information about how to use Microsoft Access forms within
Microsoft Excel, click the Index tab in Microsoft Excel Help, type the
following text
Access Form Wizard
and then double-click the selected text to go to the "Add-in programs and
other programs included with Microsoft Excel" topic.
Keywords: KB140623
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch