Hi Folks!

I am converting Excel spreadsheets to an Access DB. One field contains
approximately 200 values. In excel, when the user selects the cell where
this data resides, a little pop up window shows the entire string. Can I do
this in Access??? (The user prefers to do it in the table where the data
resides. I would prefer a form). TIA for your assistance.

Sincerely,

Stuart E. Wugalter
Zilkha Neurogenetic Institute
University of Southern California
wugalter (AT) usc (DOT) edu

I cant think of a way to do this for a datasheet view, but on a form
you should be able to programatically set the controltiptext property
to the value of the control.

txtTest.ControlTipText = txtTest.Value

best place would be the Forms OnLoad Event I expect.

-John


"Stuart E. Wugalter" <wugalter (AT) usc (DOT) edu> wrote

Keep the user out of the tables. Always use forms for massaging your data.

You can make textboxes any size you want. There is a zoom function you
could use as a pop-up by detecting the mouse over the textbox.

HTH
--
-Larry-
--

"Stuart E. Wugalter" <wugalter (AT) usc (DOT) edu> wrote