ControlTip Text Problem

[NoSmoke]

Just tried out ControlTip Text on some command and toggle buttons. The text pops up on some but not on others and I cannot determine what the difference is (the properties are essentially the same except for name, caption etc). What buttons work and what do not seems random but if I copy/paste a button that works, the copy always seems to work.

Can anyone please help with this?

 

[Pat Hartman]

There is always a delay before the ControlTip pops up. Are some of the toggle buttons part of an option group? ControlTips may not pop up for individual buttons of an option group.

 

[NoSmoke]

No, they aren't part of an option group. Only other thing I can think of is that the database was converted from Access/Office 97 to 2010. The conversion caused a couple of issues but they are resolved and AFAIK are unrelated.

Addendum:

Tried creating a new database (in 2010) with ControlTip text in a variety of controls. They all worked as expected so it looks like my project database may have become cocked up in the conversion from 97. I suppose I could delete and recreate the form but it has over 100 controls so I don't really want to do that. Maybe I'll try deleting/re-installing the offending controls, or something else if anyone can suggest it.

Addendum 2:

OK, deleting/re-installing worked. Also realized all the controls that don't work are the ones that came with the conversion (the working controls were added later in 2010). Same thing BTW for text boxes. :banghead:

 

[Pat Hartman]

Try creating a new, empty A2010 database and import all the objects. Don't forget to set the references and any startup properties. This usually gets rid of any corruption type issues.

 

[NoSmoke]

Thanks for the suggestion Pat but I tried that and no change - original controls still don't work.

 

[Pat Hartman]

Very strange. Try exporting the form to text -
Application.SaveAsText acForm, "formname", "pathAndFormName" & ".txt"

See if you can identy what is different about the controls that work and those that don't. If you can't, post the text file and tell us which work and which don't and perhaps someone else can see the problem. You could also try reimporting the form from text although that should have been the basic procedure used by Access when transferring the form from one database to another. Maybe Access takes shortcuts that the actual save as text and import from text don't.

Application.Application.LoadFromText acForm, "sfrmReconcilePayments", "C:\Pat\RAS\TextFiles120926A\Form_sfrmReconcilePayments.txt"

 

[NoSmoke]

Hey Pat, I'm not sure what the statements are for (are they VB code and if so, what do with it?).

Anyhow, tried exporting to text by right click (on the objects menu on LHS of screen)/form/export/text file/windows (default) and I get a "There isn't enough memory to perform this operation........". Tried another smaller form and Access crashed/restarted. Tried a smaller yet form and it ran but the text output was only a table of sorts containing the field values for the related table records.

It looks like this dbase conversion business has some pitfalls (although it seems to run properly otherwise other than the ControlTip text thing).

 

[Wayne]

Try going into Design View on your form. Highlight any one of the fields that the Control Tip Text is not showing up for. Right click on that highlighted field, choose "Position", and click on "Bring to Front". Now go back to Form View and try it again. Now it should appear (as long as you have entered some text into the Control Tip Text property).

This is usually a result of having different objects in close proximity on a form, such as placing a field inside a rectangle or something like that.

Hopefully this helps.

Wayne

 

[Wayne]

Sorry - forgot to add that I am using Access 2007. Should be the same in 2010.

Wayne

 

[NoSmoke]

Bingo Wayne! Yes, the objects were inside a close-by rectangle (which was added after the dbase was ported to 2010). Removing the rectangle made it work and vice-versa when the rectangle was replaced. Bringing the objects forward then made it work again.

Thanks much (from another Crazy Canuck).

 

[Wayne]

Great. Glad to help out. What part of Canada you from?

Wayne

 

[NoSmoke]

Cowtown