Access 2007 Multiple Control tip texts

[AlexanderBB]

My form view is set to continuous and I'd like a text box control tip text that could be unique for every record.

Is that possible ? Hopes !!!

I'm also wondedring is the delay before it shows is adjustable ?

Thanks.

 

[HiTechCoach]

My form view is set to continuous and I'd like a text box control tip text that could be unique for every record.

Is that possible ? Hopes !!!

Unfortunately the built in tool tip is designed to provide a tip to the user about the control in the form, not the data in the record.

You will have to use VBA code to do what you want.

I'm also wondedring is the delay before it shows is adjustable ?

There is not a way to control the delay for the control tip showing that I have seen.

 

[AlexanderBB]

Thanks HiTechCoach. We have some idea for VBA... one thing I noticed in Form Design View (and not sure how it happened or what it was). A text box control
acquired a small coloured triangle shape in one of the corners. Similar to the comment indicator in Excel, and is what I hope to use it for - if it
can be displayed somehow. If yes, I would use the mouse over event to display a comment-like Form.

 

[HiTechCoach]

Thanks HiTechCoach. We have some idea for VBA... one thing I noticed in Form Design View (and not sure how it happened or what it was). A text box control
acquired a small coloured triangle shape in one of the corners. Similar to the comment indicator in Excel, and is what I hope to use it for - if it
can be displayed somehow. If yes, I would use the mouse over event to display a comment-like Form.

In design mode of a form oe report , in the upper left corner of objects an indicator will appear where there is an errors with the object. Some you can click on the indicator to see the error message.


What are you wanting to display that could be unique for every record?

 

[AlexanderBB]

I want some (not all) records to have a visual indication an Excel-like comment exists. Then as it's moused-over, show the comment (which will have to be a small popup Form I suppose).

Have just found I cannot have a image control... and Googling up on attachment fields. Is that the way to go ? Unclear if they'd work. But if it would enable a small grahic
like this
-- removed inline image ---
to each row, it'd be mission achieved.

 

[AlexanderBB]

Oops, the graphic pasted in Ok while writing, but has gone now. It's a very small image that would fit on a row in continuous form mode.

 

[HiTechCoach]

I link the way yu are thinking. I do agree this could add to a better UX.

It is not easy to to get an unbound controls to show for only certain records in a continuous form. This been an issue with Access continuous form mode for since I started with Access 2.0 (early 1990's)

I have some ideas. Let me see what I can do.

Post back soon...

 

[AlexanderBB]

I've found something which will display the line number and contents of one field.

ContinuousFormsCurrentRowVer7.mdb

It need converting and one modification for the scrolling to work in Access 2007. which I have. It's more complicated than I can understand, but if it
could be altered to output any row number and column number the mouse is over, that could trigger a comment-like form (where required).

But you may be well on the way with something else, but if you to see this, I have it.

And many thanks for helping out..

 

[HiTechCoach]

Can you provide a link to where you found the ContinuousFormsCurrentRowVer7.mdb?

 

[AlexanderBB]

By all means..

http://www.lebans.com/DownloadFiles/ContinuousFormsCurrentRow.zip

I converted it to accdb then found a change needed in Function fIsScrollBar

If fGetClassName(hWnd_VSB) = "scrollbar" Then

to

If fGetClassName(hWnd_VSB) Like "*scroll*" Then