Results 1 to 7 of 7
  1. #1
    acierno1 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    6

    Hyperlink Control Formatting Issue

    I have a hyperlink control on a form that works perfectly except for how it turns into a block of color once the hyperlink is either clicked on or if I advance through the records, it will flash the hyperlink briefly and then block out the hyperlink with a block of color. I have tried selecting different themes and adjusting the foreground and background colors without any luck. Any ideas on how to resolve this issue? (attached example)
    Click image for larger version. 

Name:	accessdb.png 
Views:	12 
Size:	92.2 KB 
ID:	26084

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,511
    Probably because that field has the focus. Can you move the focus off of that field onto another control either in the OnOpen or OnCurrent Events of the form? Or maybe try doing Conditional Formatting when that field gets focus make background White.

  3. #3
    acierno1 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    6
    I set the "Enabled" property to "No" for the control and this stopped the colored block issue, but obviously this was just a trouble shooting step.
    When I set the Conditional Formatting to a default background and the font blue, all it does it change the block to blue when it is enabled.
    I cannot figure out how to change a focus on a field. There is information out there, but a lot of it contains assumed Access knowledge and I am new to coding in Access.

  4. #4
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,511
    In the OnOpen Event of that form, add:

    Me.YourFieldName.SetFocus

    Change the "YourFieldName" to another field or action button like a Save Button on that form.

    Also maybe on that text box field, find the property TabStop and change it to No.

  5. #5
    acierno1 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    6

    Worked, sort of :)

    Thank you. I tried the above and for an unknown reason, the text would not render in the hyperlink box.
    What I ended up doing is the below, which is not the ideal solution as it takes a while sometimes for the text to appear in the hyperlink control. It is there, if I hover over the hyperlink control I see the web address and the web browser control shows the correct document, but it takes a while for the text to render in the text box that contains the hyperlink.
    Side Note: I also had to adjust the security on the Adobe pdf reader to avoid getting error There is a problem with Adobe Acrobat/Reader. If it is running exit and try again (523:523) by opening the reader then going to Edit/preferences/ securiyt(enhanced) and unchecking enable protect mode at startup. I did not have this error prior to changing the focus.
    Click image for larger version. 

Name:	10-11-2016 1-50-25 PM.png 
Views:	8 
Size:	139.7 KB 
ID:	26090
    UPDATE: It appears this rendering issue only happens when using the form within the navigation form. When I use the form directly, the rendering issue does not occur.

  6. #6
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,511
    Maybe try using a label instead of a text box? Replace Label4 with name of your label and maybe "http:\\www.cnn.com" with your field Name1?

    Me.Label4.HyperlinkAddress = "http:\\www.cnn.com"
    Me.Label4.Caption = "cnn"

  7. #7
    acierno1 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    6
    Changing TabStop to "No" was the key. Considered this issue resolved.
    Thank you,
    Melissa

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

Similar Threads

  1. Hyperlink Control not working.
    By MatthewGrace in forum Access
    Replies: 2
    Last Post: 11-27-2015, 01:23 PM
  2. Replies: 8
    Last Post: 06-19-2015, 02:19 AM
  3. Hyperlink Field Custom Formatting?
    By excellenthelp in forum Access
    Replies: 1
    Last Post: 08-12-2014, 02:02 PM
  4. Hyperlink from subform issue
    By vad77 in forum Forms
    Replies: 2
    Last Post: 03-06-2014, 07:48 AM
  5. Replies: 9
    Last Post: 05-07-2012, 06:11 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