Microsoft KB Archive/92814

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

PRB: No Error Msg When BoundColumn Greater Than ColumnCount

Article ID: Q92814
Creation Date: 16-NOV-1992
Revision Date: 30-NOV-1996 The information in this article applies to:

  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS


Novice: Requires knowledge of the user interface on single-user computers.

The default value for the ColumnCount and BoundColumn properties of list boxes and combo boxes is 1. If you change the BoundColumn property to a number that is greater than the number of columns (ColumnCount), you do not receive an error message.

CAUSE


Microsoft Access does not enforce any error checking at this point of form or report design. Otherwise, you would always have to enter the correct column count before entering the bound column number.

RESOLUTION


When using list boxes or combo boxes, check to ensure that the BoundColumn property setting is an integer between 0 and the number set by the ColumnCount property.

STATUS


This behavior is by design.

REFERENCES


For more information about this topic, search the Help Index for "ColumnCount" and "BoundColumn," or ask the Microsoft Access 97 Office Assistant.



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.

©1997 Microsoft Corporation. All rights reserved. Legal Notices.


KBCategory: kbusage kberrmsg
KBSubcategory: FmsCmbo
Additional reference words: 1.00 1.10 2.00 7.00 97