control tip texts to show field text upon which mouse rests

[Happy YN]

I have a form where the fields are crowded so one can't see eveything in them. I want the user to be able to hover over them and the full text will appear. I thought of using control tip texts but I want to know if I can somehow program the text so that it will depend upon the field which it hovers
Is this poss. & how? or any other way?
Thanks

 

[Robert Dunstan]

Try this in the Mouse_Move event

Me.yourControlName.ControlTipText = Me.yourControlName.Value

 

[Happy YN]

Thats good but it only works on a control like a cmd button. Although the mouse move on a field name allows for the controltiptext, in a continuous form it just flashes the whole time as if looping but I see no tiptext
Any more help
Thanks

 

[Robert Dunstan]

Apologies for that, I should have read your post properly

The suggestion I gave would be fine for one record but it wouldn't update itself if you hover the mouse over the next record of the same field.

As an alternative this is what I use which may help you:

Create a label on your form and then you can set the caption of the label to the contents of each field on your form by placing this code in each of your controls GotFocus event

lbControlTip.Caption = txtMyControl.Value

You can also concatenate as well

lblControlTip.Caption = txtMyControl.Value & " " & txtMyControl2.Value etc...

HTH
Rob

 

[Rich]

You could use the Caption of the form to display relevant information as the user scrolls through the records.

 

[Happy YN]

Both good suggestions thanks alot for that .
Rich the form caption would probably not be as showy & noticeable as the label option but either way it still needs the user to click in the field
Is there really no way that they could just whizz the mouse over the fields to see whats in them?
Yours gratefully
Happy YN

 

[Pat Hartman]

If you put the following in the MouseMove event of your control, that might be what you want.

Me.YourField.ControlTipText = Me.YourField

On further reflection, this probably won't work on a continuous form because it would require a record to have the focus and if you're not clicking on anything, you're not moving the focus. I don't think that you will find any option that doesn't require clicking because of the problem of needing to identify which record is current in order to extract the value you want to show.

 

[Happy YN]

Thanks Pat
pity! It would have been so good!

 

[AndyBannister]

Actually I think it could be done. Have a look at:

http://www.experts-exchange.com/Databases/MS_Access/Q_20335899.html

Is the solution posted there what you were trying to do?

Andy

 

[ColinEssex]

If your form is very crowded, have you considered using seperate pages to break it up a bit. A crowded form can be very daunting for some users.

Col

 

[Pat Hartman]

Andy, I tried it and it shows the value for the current record no matter which row the mouse moves to.

 

[AndyBannister]

Pat,

That's odd. I tried it, and it worked fine.

Andy

 

[Rich]

It's actually a cheat, by selecting the record the mouse moves to, clever though

 

[Happy YN]

Thank you Andy for pointing out that interesting article. I have tried it but somehow I can't make any controltip appear. It works in a continuous form but I can't get it to work in the datasheet view?
Thanks again