Re: [MSAccessProfessionals] Hyperlink field not working when bulk importing http sites

instead of storing a hyperlink in the field, you can make it Short Text, 255 -- and use a form instead of the table directly. Then perhaps make the control double-click or right-click event (or a command button) do this:

with me.Controlname
   if isNull(.value) then exit sub
   application.FollowHyperlink .value
end with

kind regards,
crystal

Let's connect and work together!
http://msaccessgurus.com

On 5/2/2020 6:44 AM, anzus101 wrote:

Guys,
This is a simple problem; I hope you can help me solve it.

When I manually copy and paste an HTTP onto an ms access hyperlink field, the field DO redirect you to the site when clicking. If I import the HTTP sites from a crawler, when clicking on the field is not working.

Could you please help me to solve my problem. Thanks.