ControlTipText

[ChrisDo11]

controltip text??

i would like to use something similar to the controltip text feature. i have a form in which the user selects a company. the form enters this company into a table. the company name, street, city, province, are all different fields. only the company name is displayed on the form(after its selected from a drop down). Is there a way to have the rest of the company address show up in the form if the user hovers over the company name?

thanks....

 

[dcx693]

Never tried this myself, but you can set the control tip property using this code:
Me.cboComboBox.ControlTipText="whatever you want".

When the mouse pointer moves above a combo box, the MouseMove event fires. Try setting the control tip text for the combo box using whatever info is currently in the combo box.

Don't know if it will work, but give it a shot.

 

[ChrisDo11]

thanks for the reply.....

i tried;

Me.companyname.ControlTipText = "me![companystreet]"


but it shows "me![companystreet]" instead of the actual street name.

 

[Mile-O]

That's because you making it display a literal string.

Me.CompanyName.ControlTipText = Me.CompanyStreet

 

[ChrisDo11]

thanks.... works great...

as you can tell, i don't know much about access....