Microsoft KB Archive/140623

= 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.

