Required Field Does Not Fit in the Data Form in Q+E

 Last reviewed: November 2, 1994
Article ID: Q66533
Summery:

If you have more fields than will fit in the Data Form and one of the fields that will not fit is of the type NOT_NULL, you cannot add records using the Edit Add Records command.

Workarounds

There are three possible workarounds, as follows:

  1. Reorganize the fields so that the required fields are listed first. This may only be done by the administrator or a user who has owner privileges.

  2. Modify the SELECT statement, excluding enough fields to allow the required fields to appear in the Data Form.

  3. Cut and paste new records from Excel.

KBCategory: kbother
KBSubcategory:



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.