ControlTipText to label

[jenn87]

I've loaded an activeX document on a form. It is a DWF file of a pipeline map that has URL's. I've got the map displaying the URL by setting a ControlTipText in the doMouseOverURL. Is it possible to put a label or text box on the form that displays the ControlTipText value? I'm sure there's no need to say I'm new to VBA. Please help, I'm getting tired of having to delete all the temporary files I generate everyday trying to find the solution.

 

[FoxProProgrammer]

Hi Jenn,

I'm not sure if I understand what you want to do, but I'll take a stab at it. Let's say that you have a text box on the form named txtControlTip that will display the tip. You can assign the value of the text box like this:

txtControlTip.Value = controlname.ControlTipText

The problem is that you need to determine which URL the mouse is hovering over so you can replace "controlname" with a specific control name. Alternatively, you could replace the entire right side of the assignment with the value of the control tip text. Does the ActveX object have a property that returns the ControlText tip for the current object?

The event doMouseOverURL must be peculiar to the ActiveX control that you are using, and I am not familiar with it. I really don't know if I understood your question. Why do you want to display the ControlTip text in a text box?

Sorry that I can't help more. Hopefully someone else will have more ideas for you. dz
dzaccess@yahoo.com

 

[FoxProProgrammer]

Here's another idea. If you can tell which URL that you are hovering over in the doMouseOverURL event, you could assign the value of the text box there. I know that this works for the standard controls that come with Access such as combo boxes, list boxes, text boxes, etc. In this case, you could assign the value of the text box in the On Mouse event of each control. If I understood more about the ActiveX control that you are using, I could probably give you some more suggestions. dz
dzaccess@yahoo.com

 

[jenn87]

You don't know how much you helped. I assigned the value in the DoMouseOverURL and it worked fine. Just FYI the event is in the Whip ActiveX. Just looking for a fix until I conquer my ultimate dream of clicking on the URL on the DWF and opening a form with information about the segment. May be utilizing your suggestions I can do this. Thanks again.

 

[FoxProProgrammer]

That's great...glad to be of help, and thanks for letting me know.

I have worked on forms in the past where you click on a URL to open a document. That sounds like it is similar to what you want to do. If you decide to do it and need help, let me know. dz
dzaccess@yahoo.com