IsHyperlink not working for Unbound Textbox

[DRedDog]

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.

 

[Tom van Stiphout]

On Sat, 8 May 2010 01:56:46 -0400, "DRedDog" <[email protected]>
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

 

[DRedDog]

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

DT

 

[Dirk Goldgar]

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]

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.

 

[David Taylor]

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 tex
box does not make it behave as a hyperlink; it just causes it to b
formatted as hyperlinks are formatted. You can use code to make it behav
as a hyperlink, and even (with a little difficulty in Access 2003) make
hand cursor appear when mousing over it

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

-
Dirk Goldgar, MS Access MV
Access tips: www.datagnostics.com/tips.htm

(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/tutorial...7af-c38852b3b455/book-review-effective-c.aspx

 

[Peter Hibbs]

David,

Perhaps this might help :-

http://bytes.com/topic/access/answers/662035-changing-mouse-cursor

Peter Hibbs.

 

[DRedDog]

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

 

[Dirk Goldgar]

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.

 

[Peter Hibbs]

David,

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

Peter Hibbs.

 

[DRedDog]

My mouse pointer now changes to a hand as it passes over my unbound text
boxes . And it does not flicker (too much) like some other solutions I have
tried. Thanks to all who have responded; especially Dirk Goldgar and Peter
Hibbs.

DT