Error: failure of the list portion of a combo box to remain visible
The error appears to be due to code in a conditional statement that
set the ControlTipText property of the combo box to different values
depending on whether the conditional evaluated as true or false. The
code occurs in the MouseMove event of the affected combo box.
For example:
Private Sub CtlComboBox_MouseMove(Button As Integer, Shift As Integer,
x As Single, Y As Single)
If IsNull(Me.CtlName.Value) Or IsNull(Me.CtlNameAnother.Value)
Then
Me.CtlComboBox.ControlTipText = "True part"
Else
Me.CtlComboBox.ControlTipText = "False part"
End If
End Sub
Experienced the following results on two systems:
1. Access 2002 Service Pack 2 / Operating System - XP
2. Access 2003 Windows 2K, service packs unknown
Results:
With neither true nor false commented out, the list always remained
visible.
With both true and false active, the list never remained visible.
With only true active, the list remained visible only if the
conditional evaluated to false.
With only false active, the list remained visible only if the
conditional evaluated to true.
The list portion remains displayed with all other systems tested thus
far (various permutations of Access 97, 2k, 2k2 with OS of Windows 98,
NT, 2000).
I fixed this by displaying the desired text in the status bar rather
than as a tool tip but I'm still puzzled by the problem. I couldn't
find any relevant information in the MS knowledgebase or MVPS. Any
ideas?