Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mouse Over? (Access 2003)

    I have a list box on a form with multiple columns. Would it be possible to mouse over a particular entry record and have an entire memo field be displayed?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mouse Over? (Access 2003)

    It would require using Windows API functions to calculate which list item the mouse pointer is over from the X and Y coordinates passed by the On Mouse Move event procedure. Far from trivial stuff.
    It would be far easier to display info about the currently selected item.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mouse Over? (Access 2003)

    the VB code to do something like that can be found on the web, but its probably a bit different coding in access. VB3 and earlier didn't have tool tip options in the properties boxes I don't think, so there should be material on it.

    correct me if im wrong Hans <img src=/S/bow.gif border=0 alt=bow width=15 height=15> <img src=/S/king.gif border=0 alt=king width=21 height=22>
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  4. #4
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mouse Over? (Access 2003)

    How do you suggest I go about trying it for the currently selected item?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mouse Over? (Access 2003)

    Stephen Lebans has an example of how to react to the On Mouse Move event of a list box; it could be adapted, but I don't like the way it works (Stephen wrote in 1999 that it was a very primitive example, but he never got round to enhancing it). See ListboxAuto1.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mouse Over? (Access 2003)

    You can set the caption of a label in the After Update event of the list box. I have attached a demo using the Employees table from the Northwind database. The Notes field from the table is the 4th column of the list box, but it is hidden. When the user clicks an item, the caption of the label is set to the value of the 4th column.

  7. #7
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mouse Over? (Access 2003)

    thanks Han, this is a good alternative!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •