Memo fields on mouseover

[Alex Hammerstein]

Hi

I have a continuous sub-form which displays the date, creator and details of
notes relating to jobs. The note text field is a memo field. Against each
note I have placed a Read button which will display the whole record in a
pop up form.

However I was wondering, is there any way to allow a user to see the whole
contents of the note text by simply mousing over the text area? I know you
can do this on web sites, but not sure in Access

Many thanks

Alex

 

[Arvin Meyer [MVP]]

You can use ControlTip text but only for 255 characters. You could also open
your popup form using the mouseover event. The later may be a problem since
it will fire and you'll have to wait to enter text in the memo.

 

[Alex Hammerstein]

Thanks Arvin

Alex

 

[Krzysztof Naworyta]

Juzer Alex Hammerstein <[email protected]> napisal


(...)
| However I was wondering, is there any way to allow a user to see the
| whole contents of the note text by simply mousing over the text area?
| I know you can do this on web sites, but not sure in Access


This is very problematic in a continuous form.
After many years of experience with MS Access I used to say that nothing
is impossible in it, but this is just very difficult.

There is an event "OnMouseMove," but there is no event "OnMouseOver".
And there is very difficult to indicate which line/record you should read
data from...
Me.Control1 provides access to the current record (which has a focus)
How to indicate record you moving mouse over?
Very complicated...

 

[Alex Hammerstein]

Thanks, I have decided not to offer that facility.

Alex

 

[Alex Hammerstein]

Thanks, I have decided not to offer that facility.

Alex

 

[David W. Fenton]

See:
http://www.lebans.com/conformscurcontrol.htm

ContinuousFormsCurrentRow.zip is a class that allows you to
programmatically access the contents of a bound control, as the
user moves their Mouse, but the control does not have the focus.
For Forms in Continuous View.

Gad, I wish I'd known about this last week, as I needed it! Instead,
I implemented a shortcut menu.

I may just replace that with yours.

And, it just goes to show that if it's something advanced and cool
and sensible, Stephen Lebans has probably already implemented it!

 

[David W. Fenton]

See:
http://www.lebans.com/conformscurcontrol.htm

ContinuousFormsCurrentRow.zip is a class that allows you to
programmatically access the contents of a bound control, as the
user moves their Mouse, but the control does not have the focus.
For Forms in Continuous View.

Well, turns out I'd downloaded that years ago and never used it.

It won't work unchanged for my situation, as I want to display
information not displayed on the continuous form (a large memo
field). I also don't want it limited to a single control, so I guess
I'd have to set up multiple controls (i.e., multiple instances of
the class), and disconnect the data part (i.e., the line using the
control's ControlSource property) from the mouseover events.

But I don't have time to futz with getting it to work now.