viewing entire contents of a text or memo field in datasheet view

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Is there any way to add a control that displays the
current cell contents when you are in a datasheet view?
I'm looking for something analogous to how a cell's
content appears in the toolbar of an Excel spreadsheet
when the cursor is in the cell.

Thanks
 
If this is a *form* in datasheet view you could embed the form as a subform
within a main form, and display the contents in an unbound text box on the
main form. Something like the following (untested air-code) in the Current
event of the sub form should do it ...

Me.Parent!NameOfTargetTextBox = Me!NameOfSourceTextBox

If we're talking about a table or query in datasheet view, no, but you can
use the keyboard shortcut Shift+F2 to open the built-in 'Zoom' dialog box.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top