IsHyperlink not working for Unbound Textbox

My Access 2003 form contains unbound text boxes with the IsHyperlink
property set to True but the pointer does not change to a hand as the mouse
passes over. The mouse pointer does change to a hand if the text box is
bound to a data source.
Please tell me how to make the mouse pointer change to a hand as it passes
over an unbound text box.

On Sat, 8 May 2010 01:56:46 -0400, "DRedDog"
wrote:

When unbound, the change of the mouse pointer happens when you hover
over the text in the textbox, not over the empty space in the textbox
(unless you go out of your way and fill it with Space characters).

-Tom.
Microsoft Access MVP


My Access 2003 form contains unbound text boxes with the IsHyperlink
property set to True but the pointer does not change to a hand as the mouse
passes over. The mouse pointer does change to a hand if the text box is
bound to a data source.
Please tell me how to make the mouse pointer change to a hand as it passes
over an unbound text box.

Thanks for your response but my mouse pointer remains an I beam when it
passes over the text in the text box control.

DT

"Tom van Stiphout" wrote in message
...
On Sat, 8 May 2010 01:56:46 -0400, "DRedDog"
wrote:

When unbound, the change of the mouse pointer happens when you hover
over the text in the textbox, not over the empty space in the textbox
(unless you go out of your way and fill it with Space characters).

-Tom.
Microsoft Access MVP


My Access 2003 form contains unbound text boxes with the IsHyperlink
property set to True but the pointer does not change to a hand as the
mouse
passes over. The mouse pointer does change to a hand if the text box is
bound to a data source.
Please tell me how to make the mouse pointer change to a hand as it
passes
over an unbound text box.

"DRedDog" wrote in message
...
My Access 2003 form contains unbound text boxes with the IsHyperlink
property set to True but the pointer does not change to a hand as the
mouse passes over. The mouse pointer does change to a hand if the text box
is bound to a data source.
Please tell me how to make the mouse pointer change to a hand as it
passes over an unbound text box.


So far as I can tell, setting IsHyperlink to Yes/True for an unbound text
box doesn't make it behave as a hyperlink; it just causes it to be
formatted as hyperlinks are formatted. You can use code to make it behave
as a hyperlink, and even (with a little difficulty in Access 2003) make a
hand cursor appear when mousing over it.

It's not hard to do, but maybe there's an easier way to accomplish your
goal. Why exactly are you using an unbound text box as a hyperlink, rather
than a label with a hyperlink address, or a control bound to a hyperlink
field? What are you really trying to do?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

"Dirk Goldgar" wrote in message
...

So far as I can tell, setting IsHyperlink to Yes/True for an unbound text
box doesn't make it behave as a hyperlink; it just causes it to be
formatted as hyperlinks are formatted.

Note: I believe ADPs are different from MDBs in this regard. Although I
haven't used hyperlinks in ADPs, I gather from various side comments in help
topics that in ADPs, setting a control's IsHyperlink property to True makes
it behave as a hyperlink, while in MDBs the underlying field must have the
Hyperlink data type.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

The Click events of the text box controls on a splash screen open forms - not web pages or files. I want the mouse pointer to change to a hand as the mouse rolls over each control.
I thought that the text box IsHyperlink property would do this for me - so I chose text boxes.

I'm stuck with Access 2003 on this one and I don't mind a "little difficulty".

Thanks,

DT

Can clicking a label with a hyperlink address open a form?



Dirk Goldgar wrote:

So far as I can tell, setting IsHyperlink to Yes/True for an unbound textbox
09-May-10

So far as I can tell, setting IsHyperlink to Yes/True for an unbound text
box does not make it behave as a hyperlink; it just causes it to be
formatted as hyperlinks are formatted. You can use code to make it behave
as a hyperlink, and even (with a little difficulty in Access 2003) make a
hand cursor appear when mousing over it.

it is not hard to do, but maybe there is an easier way to accomplish your
goal. Why exactly are you using an unbound text box as a hyperlink, rather
than a label with a hyperlink address, or a control bound to a hyperlink
field? What are you really trying to do?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
BOOK REVIEW: Effective C#, Second Edition [Addison Wesley]
http://www.eggheadcafe.com/tutorials...fective-c.aspx

David,

Perhaps this might help :-

http://bytes.com/topic/access/answer...g-mouse-cursor

Peter Hibbs.

On Sun, 09 May 2010 11:57:25 -0700, David Taylor wrote:

The Click events of the text box controls on a splash screen open forms - not web pages or files. I want the mouse pointer to change to a hand as the mouse rolls over each control.
I thought that the text box IsHyperlink property would do this for me - so I chose text boxes.

I'm stuck with Access 2003 on this one and I don't mind a "little difficulty".

Thanks,

DT

Can clicking a label with a hyperlink address open a form?



Dirk Goldgar wrote:

So far as I can tell, setting IsHyperlink to Yes/True for an unbound textbox
09-May-10

So far as I can tell, setting IsHyperlink to Yes/True for an unbound text
box does not make it behave as a hyperlink; it just causes it to be
formatted as hyperlinks are formatted. You can use code to make it behave
as a hyperlink, and even (with a little difficulty in Access 2003) make a
hand cursor appear when mousing over it.

it is not hard to do, but maybe there is an easier way to accomplish your
goal. Why exactly are you using an unbound text box as a hyperlink, rather
than a label with a hyperlink address, or a control bound to a hyperlink
field? What are you really trying to do?

Thanks, Peter Hibbs. Setting the value of myLabel.HyperlinkAddress to " "
(space character) does cause the mouse pointer to change to a hand as the
mouse passes over myLabel. But it also causes the space character to be
displayed in little box under the hand. If I could get rid of that little
box then my problem would be solved. Any ideas?

DT

"Peter Hibbs" wrote in message
...
David,

Perhaps this might help :-

http://bytes.com/topic/access/answer...g-mouse-cursor

Peter Hibbs.

On Sun, 09 May 2010 11:57:25 -0700, David Taylor wrote:

The Click events of the text box controls on a splash screen open forms -
not web pages or files. I want the mouse pointer to change to a hand as
the mouse rolls over each control.
I thought that the text box IsHyperlink property would do this for me - so
I chose text boxes.

I'm stuck with Access 2003 on this one and I don't mind a "little
difficulty".

Thanks,

DT

Can clicking a label with a hyperlink address open a form?



Dirk Goldgar wrote:

So far as I can tell, setting IsHyperlink to Yes/True for an unbound
textbox
09-May-10

So far as I can tell, setting IsHyperlink to Yes/True for an unbound text
box does not make it behave as a hyperlink; it just causes it to be
formatted as hyperlinks are formatted. You can use code to make it behave
as a hyperlink, and even (with a little difficulty in Access 2003) make a
hand cursor appear when mousing over it.

it is not hard to do, but maybe there is an easier way to accomplish your
goal. Why exactly are you using an unbound text box as a hyperlink,
rather
than a label with a hyperlink address, or a control bound to a hyperlink
field? What are you really trying to do?

"David Taylor" wrote in message ...
The Click events of the text box controls on a splash screen open forms -
not web pages or files. I want the mouse pointer to change to a hand as
the mouse rolls over each control.
I thought that the text box IsHyperlink property would do this for me - so
I chose text boxes.

I'm stuck with Access 2003 on this one and I don't mind a "little
difficulty".


You can use Windows API calls to change the cursor in the control's
MouseMove event. With the code from this link:

http://www.mvps.org/access/api/api0044.htm

.... in a standard module, you can set your text box's OnMouseMove property
to this expression:

=MouseCursor(32649)

The cursor will change to a "hand" while the mouse is over the control, and
change back automatically when you move it off the control.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

David,

See Dirk Goldgar's reply which would be the easiest to use. Post back
if you have any problems implementing it.

Peter Hibbs.

On Mon, 10 May 2010 07:59:04 -0400, "DRedDog"
wrote:

Thanks, Peter Hibbs. Setting the value of myLabel.HyperlinkAddress to " "
(space character) does cause the mouse pointer to change to a hand as the
mouse passes over myLabel. But it also causes the space character to be
displayed in little box under the hand. If I could get rid of that little
box then my problem would be solved. Any ideas?

DT

"Peter Hibbs" wrote in message
.. .
David,

Perhaps this might help :-

http://bytes.com/topic/access/answer...g-mouse-cursor

Peter Hibbs.

On Sun, 09 May 2010 11:57:25 -0700, David Taylor wrote:

The Click events of the text box controls on a splash screen open forms -
not web pages or files. I want the mouse pointer to change to a hand as
the mouse rolls over each control.
I thought that the text box IsHyperlink property would do this for me - so
I chose text boxes.

I'm stuck with Access 2003 on this one and I don't mind a "little
difficulty".

Thanks,

DT

Can clicking a label with a hyperlink address open a form?



Dirk Goldgar wrote:

So far as I can tell, setting IsHyperlink to Yes/True for an unbound
textbox
09-May-10

So far as I can tell, setting IsHyperlink to Yes/True for an unbound text
box does not make it behave as a hyperlink; it just causes it to be
formatted as hyperlinks are formatted. You can use code to make it behave
as a hyperlink, and even (with a little difficulty in Access 2003) make a
hand cursor appear when mousing over it.

it is not hard to do, but maybe there is an easier way to accomplish your
goal. Why exactly are you using an unbound text box as a hyperlink,
rather
than a label with a hyperlink address, or a control bound to a hyperlink
field? What are you really trying to do?