Microsoft KB Archive/92814

{|
 * width="100%"|

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 &quot;ColumnCount&quot; and &quot;BoundColumn,&quot; or ask the Microsoft Access 97 Office Assistant.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; 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