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

• 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

and then double-click the selected text to go to the "Add-in programs and other programs included with Microsoft Excel" topic.

Additional query words:

Keywords          : xlwin 
Version           : 7.00
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: July 29, 1999