Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2009
    Posts
    67

    Unanswered: Message on mouse move

    Is it possible to to have comment pop up when mouse is placed at top of field on form same way as comments on excel.

    Thanks

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    The Control Tip Text property won't work for you?
    Me.Geek = True

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    I prefer using MouseMove and a label, as the Control Tips tend to be unreliable at times and you can format labels as you like. Here's an example:

    Code:
    Private Sub ClientName_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
       lblClientNameHelp.Visible = True
    End Sub
    
    Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
       lblClientNameHelp.Visible = False
    End Sub
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    In the Mousemove event for the control, you could have it show a popup (specially positioned and designed to show your message) or you could possibly force the control tip text to show.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Control Tips are perfectly reliable for me... but there is a trick to them that might give you the impression that they are not stable. If you have controls inside objects like rectangles, you need to send the rectangle to the back if you want things inside that rectangle to show tooltips when not selected. Once you get past that, they are perfectly reliable.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    That's the advice everybody gives, but not my experience. I find them unreliable even when freestanding, i.e. not within rectangles, etc. Stopped depending on them years ago. And even when they do work, esthetically thry're not much to look at, since formatting them is a no go.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I guess your customers don't care how much time / money their project costs
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    If you decide to use a form for the message, I'd suggest you look at the "Form Manipulation" examples in the code bank. You can remove the caption bar and make it look more pleasing and less like a form (you can even make it an oval shaped form without a caption bar or fade-in/out or set the transparency to 20%, 50%, or any percentage you wish!!)

    Here's the link: http://www.dbforums.com/6301669-post51.html
    Last edited by pkstormy; 06-01-09 at 21:21.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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