Trouble setting hyperlink string with code

[pemigh]

If I type
www.microsoft.com
into the control txtSearchString which is bound to a hyperlink field, I
can click it and automatically zoom off to the web page.
But if I try to set the field with this snippet of code
Me.txtSearchString = "www.microsoft.com"
DoCmd.RunCommand acCmdSaveRecord
clicking on the field does nothing.

Well, not quite nothing. A tiny little square appears under the pointy
hand.

Any ideas?

pemigh

[pemigh]

I answered my own question. This works:
Me.txtSearchString = "www.microsoft.com#http://www.microsoft.com#"

Apparently Access does this concatenation when you type in the text,
but not when you set it with code. (I figure this out by using
SendKeys to mimic actually typing the text.)

pemigh


pemigh wrote:

If I type
www.microsoft.com
into the control txtSearchString which is bound to a hyperlink field, I
can click it and automatically zoom off to the web page.
But if I try to set the field with this snippet of code
Me.txtSearchString = "www.microsoft.com"
DoCmd.RunCommand acCmdSaveRecord
clicking on the field does nothing.

Well, not quite nothing. A tiny little square appears under the pointy
hand.

Any ideas?

pemigh

[pemigh]

I answered my own question. This works:
Me.txtSearchString = "www.microsoft.com#http://www.microsoft.com#"

Apparently Access does this concatenation when you type in the text,
but not when you set it with code. (I figure this out by using
SendKeys to mimic actually typing the text.)

pemigh


pemigh wrote:

If I type
www.microsoft.com
into the control txtSearchString which is bound to a hyperlink field, I
can click it and automatically zoom off to the web page.
But if I try to set the field with this snippet of code
Me.txtSearchString = "www.microsoft.com"
DoCmd.RunCommand acCmdSaveRecord
clicking on the field does nothing.

Well, not quite nothing. A tiny little square appears under the pointy
hand.

Any ideas?

pemigh