Zoom into memo field

[Jeannie]

Good Morning,

I have been trying to locate a solution for this so this
is my last resort.

I have a continuous form that displays a memo field. I
would like to "Zoom in" to that memo field in order to
both view and enter additional text. Since its a
continuous form, setting the text box height is clumsy. I
thought there was a function in utils.mdb but can't seem
to find it. Please help!!!

Thanks,

Jeannie

 

[Ted Allen]

Hi Jeannie,

A couple of things that I have done are:

1. Add a note next to the field telling the user to
press Shift+F2 for an expanded view

2. Add a large text box in the form's footer and set the
value = to the memo control in the detail section. This
method will allow the user to view and edit the memo
field for the current record in the footer control, but
if the user goes to a new record and tries to enter memo
text in the footer without first typing some info in the
detail section you may get an error if the record
involves automatic generation of unique ID's (the footer
control can't equal the value of the detail control
because there isn't a field value to link to yet). In
our case, I have a small group of users so I just told
them not to do that. But, I'm sure it could also be
handled easily by writing a short bit of code behind the
footer text box if necessary.

Just a few ideas. I'm sure others may post additional
ideas.

-Ted Allen

 

[Elwin]

Ted mentioned the Shift+F2 feature, but to expand on it;

I use the SendKeys statement to do this from the
DoubleClick() event of my text controls

SendKeys "+{F2}"

 

[Bruce M. Thompson]

Ted mentioned the Shift+F2 feature, but to expand on it;

I use the SendKeys statement to do this from the
DoubleClick() event of my text controls

SendKeys "+{F2}"

<accck! choke!> Please don't even consider using SendKeys from code in Access.
There have been issues connected to that for far too long. Instead, consider
using the following:

'**
'Set the focus to the memo field's control, if necessary
DoCmd.Setfocus "MyMemoControlName"

'No invoke the "Zoombox"
'DoCmd.RunCommand acCmdZoomBox
'**

 

[Elwin]

-----Original Message-----
<accck! choke!> Please don't even consider using SendKeys from code in Access.
There have been issues connected to that for far too long. Instead, consider
using the following:

'**
'Set the focus to the memo field's control, if necessary
DoCmd.Setfocus "MyMemoControlName"

'No invoke the "Zoombox"
'DoCmd.RunCommand acCmdZoomBox
'**


--
Bruce M. Thompson, Microsoft Access MVP
(e-mail address removed) (See the Access FAQ at http://www.mvps.org/access)
within the newsgroups so that all might benefit.<<


.

 

[Bruce M. Thompson]

ouch <hangs head and returns to dark corner under stairs>

LOL!