Memo fields on mouseover

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

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Alex Hammerstein" wrote in message
...
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

Thanks Arvin

Alex



On 08/09/2009 17:16, in article ,
"Arvin Meyer [MVP]" wrote:

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.

Juzer Alex Hammerstein 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...

--
KN

I agree with Krzysztof. You can use the "zoombox" command to zoom the control
when mousing over the memo field textbox, but it's going to display the data
from that textbox ***of the currently selected record*** not the particular
record whose memo field the user is mousing over. And I know of no practical
way to determine which record the mouse is over. Perhaps someone else does.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

Thanks, I have decided not to offer that facility. :-)

Alex




On 08/09/2009 18:14, in article , "Krzysztof
Naworyta" wrote:

Juzer Alex Hammerstein 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...

Thanks, I have decided not to offer that facility. :-)

Alex



On 08/09/2009 18:32, in article 9bd248e8e5e72@uwe, "Linq Adams via
AccessMonster.com" u28780@uwe wrote:

I agree with Krzysztof. You can use the "zoombox" command to zoom the control
when mousing over the memo field textbox, but it's going to display the data
from that textbox ***of the currently selected record*** not the particular
record whose memo field the user is mousing over. And I know of no practical
way to determine which record the mouse is over. Perhaps someone else does.

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.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Linq Adams via AccessMonster.com" u28780@uwe wrote in message
news:9bd248e8e5e72@uwe...
I agree with Krzysztof. You can use the "zoombox" command to zoom the
control
when mousing over the memo field textbox, but it's going to display the
data
from that textbox ***of the currently selected record*** not the
particular
record whose memo field the user is mousing over. And I know of no
practical
way to determine which record the mouse is over. Perhaps someone else
does.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

"Stephen Lebans"
wrote in
:

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 http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

"Stephen Lebans"
wrote in
:

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.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/