I have some hyperlinks in textboxes on a form.

When a link is clicked the background of the hyperlink text changes. I would like to disable this behavior; I don't want the appearance on the form to change.

Thanks for your help. ElbyG

ElbyG,

This is an option within Access. According to this Microsoft web page, you need to click the Office button, go to the Advanced tab and click Web Options to set the color for un-clicked and already-clicked weblinks. If you make them the same color, the color of the text won't change. However, since this appears to be an Access-specific option, and not a database-specific option, you will need to run VBA to set this option on whichever computer the database opens on.

The page I linked you to may have more options for you that could be simpler.

Hope this helps,

Dennis

Thank you Doctor9,

In this case I do want to use the hyperlink functionality.

Not sure how to set the on-clicked option with VBA on individual computers; I'll have to research that further. These are all computers within a small workgroup so it would be possible to set with code on an event.

If anyone has suggestions, please post. Thanks, ElbyG

ElbyG,

I'd check the Visual Basic Editor's help system, starting with the HyperlinkColor Property.

Hope this helps,

Dennis

Hi Elby,

This solution seems overly simple, but from what you're describing, it sounds like the "Fore Color" property of your text box is set to "Hyperlink Color", which is the default for a control based on a hyperlink field type - just change that Fore Color to whatever tickles your fancy. Your formatting will not change.

HTH,
Shawn

Not that simple but thanks...still looking.

okay...if I understand correctly, you want the text color to remain the same regardless of user clicks, right?

Correct...haven't yet figured it out.

Actually, both the fore color and back color change. The fore color becomes white and the back color becomes the fore color prior to the click event.

Thanks, ElbyG

If you're using Access 2010, and your hyperlink is stored in a table and accessed via text box on a standard form, changing the Fore Color and Back Color properties produces a static color for both. Any idea why that won't work?

I don't know why it won't work...tried this already. Still looking...