XL7: #NUM! Error Value Displayed in Microsoft Access Form

The information in this article applies to:

• Microsoft Excel for Windows 95, version 7.0

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