Don't open url if null

[jamescullis]

HI all,

I'm opening a browser at a specific page from the form using the following VBA. Just wondering if I can stop the field from being a hyperlink if the value is NULL?

CreateObject("Shell.Application").Open "http:/google.com" & Me.OpenURI

thanks in advance.

 

[moke123]

If not isnull(Me.OpenURI) then
CreateObject("Shell.Application").Open "http:/google.com" & Me.OpenURI
End If