Results 1 to 6 of 6
  1. #1
    dscott0919 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    3

    Screen tips not showing when Access report is exported to Html document


    Screen tips work when I view the report on the screen, however when downloaded in HTLM format the screen tips don't work. If I download the HTLM report directly from the Query used to create the report the screen tips work fine. Any solution to the problem?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,928
    What do you mean by 'screen tips'? Never heard of this. Controls on form/report do have a ControlTipText property. No idea how a query would have 'screen tips'.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    dscott0919 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    3
    The screen tips in a hyperlink field. When I hover the the pointer over the word in the field, the screen tips work on screen, but when I download the report in html format, the screen tips no longer pop up. Example of the field input is (1 hr/WA)#http://hacoaa.org##1 Hour Wheelchair Accessible. When you hover over the field "1 Hour Wheelchair Accessible" shows on the report, but not when I download the report in html format. I hope that make sense?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,928
    Understand now. I don't have any db set up with hyperlink fields and therefore no report to test with. Do you want to provide file for analysis? Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    dscott0919 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    3
    I have attached the database. This is a work in progress. The field that I'm concerned with is the "Code" field. Any suggestions will be much appreciated. Let me know if you have any questions. Thanks for your help.

    Diane
    Attached Files Attached Files

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,928
    The query export has option to 'Export data with formatting and layout' that is not available with the report export. If I did not check this option for the query, then the popup tip code did not generate.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Recreate Word document in Access Report
    By cphelps48 in forum Reports
    Replies: 2
    Last Post: 11-29-2011, 04:32 PM
  2. Eliminate line breaks in exported report
    By thekruser in forum Reports
    Replies: 3
    Last Post: 09-28-2010, 08:57 PM
  3. Replies: 0
    Last Post: 05-13-2010, 05:18 AM
  4. Replies: 0
    Last Post: 03-26-2010, 09:11 AM
  5. Access 2003 - Export Report to HTML
    By darth.pathos in forum Import/Export Data
    Replies: 0
    Last Post: 03-20-2010, 01:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums