ACC: Yes/No Field Not Evaluating "-1" or "0" in ComparisonsLast reviewed: May 30, 1997Article ID: Q142229 |
The information in this article applies to:
SYMPTOMSModerate: Requires basic macro, coding, and interoperability skills. Code written in Access Basic that uses "-1" or "0" (with the quotation marks) to compare a Yes/No field in a table or recordset does not work properly when you convert the Access Basic code to Visual Basic for Applications code. In Microsoft Access version 2.0, which uses Access Basic, the numeric comparisons are evaluated as strings. In Microsoft Access 7.0 and 97, which uses Visual Basic for Applications, the numeric comparisons are evaluated as Boolean values.
CAUSEIn Access Basic the condition
If rs![yesnofield] = "-1" Thenis evaluated as True, and the condition:
If rs![yesnofield] = "0" Thenis evaluated as False. In Visual Basic for Applications, these conditions are no longer evaluated in this manner.
RESOLUTIONIn an open Access Basic or Visual Basic for Application Module window, use the Find command on the Edit menu (or press CTRL+F) to check for instances of the strings "-1" or "0" (with the quotation marks). Change all instances in Visual Basic for Applications where "-1" or "0" is used to compare a Yes/No field in a table or recordset as described below. If you are using the following expression in Access Basic
IF rs![yesnofield] = "-1" Thenin Visual Basic for Applications change the code so that there are no quotation marks around the number "-1" or use the word "True" as in the following example:
IF rs![yesnofield] = -1 Then -or- IF rs![yesnofield] = True ThenIf you are using the following expression in Access Basic
IF rs![yesnofield] = "0" Thenin Visual Basic for Applications, change the code so that there are no quotation marks around the number "0" or use the word "False" as in the following example:
IF rs![yesnofield] = 0 Then -or- IF rs![yesnofield] = False Then STATUSThis behavior is by design.
MORE INFORMATION
Steps to Reproduce Behavior
REFERENCESFor more information about the Boolean data type, search the Help Index for "Boolean data type," or ask the Microsoft Access 97 Office Assistant |
Keywords : CnvGnrl kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |