textbox information

[JohnE]

Hello. This might be a simple matter to do but I am not that familiar with
it. I have a textbox that is bound to a memo field so the user can type
notes into it. This is on a continuous form and it would look/work better if
the textbox (memo field) is only one line in height. I have the textbox with
a double click event that shows the zoom box. What the users are asking for
is to be able to hover the mouse over the textbox and the info appears much
like a tool tip box does, but with the notes in the textbox.

Is something like this possible? If so, how is it done? Is there some
resource(s) available regarding it?

Thanks in advance for the assistance.

.... John

 

[Linq Adams via AccessMonster.com]

Actually, your solution is by far the best one! The problem with doing
something like this on a continuous form is that if you have code that
executes when you hover over your memo field control, the code will be
referencing that field IN THE RECORD THAT HAS FOCUS.

In other words, if Record1 has the focus, and the user moves the mouse to
hover over the memo field in Record3, the popup box will be showing the data
for the field in Record1, not Record3, as they expect. To make this work,
they'd have to click on Record3, then hover over the memo field. In reality,
they'll forget to do this ,ost of the time, and they'll be seeing data for
Record1 and thinking it's data for Record3.

Why not double click like you have it now, rather than click on the record
then hover?

 

[Dennis]

A memo field can contain roughly 32,000 characters of data. Are you saying
that you want to cram 32,000 chars into a popup tool-tip box? Cuz that's
crazy.

You COULD create a MOUSEOVER event that pops up a new form that gets loaded
with the data from the textbox, but they'd have to close the form manually.