memo pop out box

[zmenloans]

This is sort of hard to explain, but I hope you guys understand what I am
wondering. In Excel, when you have a lot of text in the cell, when you
double click on the cell the cell expands to read the text and then when you
click off it goes back to the way it was. Is there a way to do this with a
memo box in Access in a table? I wanted to read data while it was in
datasheet view but I then have to use the arrow keys to read everything
accross and scroll through the entire memo box. Can there be a way to pop
out the memo text to look at it?

Thanks

 

[Al Campagna]

zmenloans,
Use the DoubleClick event of your control...
Private Sub SomeControlName_DblClick(Cancel As Integer)
DoCmd.RunCommand acCmdZoomBox
End Sub

(see the many useful RunCommand constants available in Access Help)
I rarely use Memo fields, but that should do what you require.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[John Spencer MVP]

Put cursor in field
Press Shift + F2

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[zmenloans]

Thank you Al and John for your responses! John, that shortcut works
great...thanks!

Al, I still have a question. Can you do a DoubleClick event to a table or
only to forms and reports?

 

[zmenloans]

Thank you Al and John for your responses! John, that shortcut works
great...thanks!

Al, I still have a question. Can you do a DoubleClick event to a table or
only to forms and reports?

 

[Al Campagna]

zmenloans,
Tables, in table view, have no events, and Report text controls have no
events, ergo... no DoubleClick.
A text control on a Form, in form view or datasheet view, does have a
double click event.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."