On Sat, 08 Nov 2003 04:42:12 GMT, "Deborah V. Gardner"
<dg******@twcny.rr.com> wrote:
In my solution there is no code in any event. Just this expression in
the ControlSource of the text box. I've used this technique many
times, and have never observed the strange behavior you are
describing.
-Tom.
Tom
Thank you, that streamlined it, but I still have the same problem. I
have to hold the mouse button down twice to get the correct text.
Will I have to forego using MouseDown and use the OnClick event?
Deborah
Tom van Stiphout wrote: On Sat, 08 Nov 2003 03:18:38 GMT, "Deborah V. Gardner"
<dg******@twcny.rr.com> wrote:
Forget the code and put this in the ControlSource for the text box:
=[MyListbox].[Column](4)
-Tom.
I have a list box and would like to point to an item and have a textbox
popup referencing a column in the list box.
On the list box's MouseDown event I have the following
Dim strFullText
strFullText = Me.lstMyList.Column(4)
txtFullText.Visible = True
txtFullText = strFullText
It works but what appears in the text box is the information from the
previous selection. I have to click once and then hold the mouse down to
see the correct information.
I have read that the selection does not take place until after the
MouseDown event.
Is there a workaround for this? Or am I out of luck?
Thank you,
Deborah