URL use Access 2010

[fileman1]

Hi, I have a form with a text box which is bound to a table with the field set as Hyperlink.

I can type in

http://www.google.co.uk

and it looks blue, and I can save the record. However when I open the record, if I click my mouse on the hyperlink address it does nothing except either copy the address to one side of the text box having hash characters at each end. However I found if I right click the address, options come up to edit and open the Hyperlink, it then opens Google.

What am I doing wrong? Should I have a command button with code to say open?

 

[fileman1]

Managed to find some very simple code which works a treat

Private Sub cmd_Click()

    Dim ctl As CommandButton

    Set ctl = Me!CMD

    With ctl

        .HyperlinkAddress = "[URL unfurl="true"]http://"[/URL] & Me!UR1
 
    End With

End Sub

Hope it works for someone else too.