Expand a memo field

[Guest]

I have a form with a subform form (main form/lower subform)
The lower subform is a continuous form one of the fields (Info) is a memo
field - whilst operating the main form I can only see one line of the Info
field, I have seen where you can double click this field (or use a command
button) and it will open what looks like another form to clearly view or type
in this one field, then once closed will update the main form - how is this
done?

 

[Ken Snell \(MVP\)]

Shift+F2 usually is the keyboard shortcut to open the Zoom window.

Or you can program the doubleclick event of the textbox, or a command
button's click event, to open a Zoom window.

 

[Guest]

Whilst Shift F2 works I tried to go down the command button route, but I am
unable to find anything that actually does what I want is there some coding
or is it a macro command - got me stumped

 

[Ken Snell \(MVP\)]

Here is sample VBA code for double-clicking a textbox or for clicking a
command button:

' Double-click event of textbox
Private Sub TextBoxName_DblClick(Cancel As Integer)
DoCmd.RunCommand acCmdZoomBox
End Sub




' Click event of command button
Private Sub CommandButtonName_Click()
Me.TextBoxName.SetFocus
DoCmd.RunCommand acCmdZoomBox
End Sub

 

[Guest]

Thats great works fine, is there a simple list anywhere of things like
acCmdZoomBox

Would probably save me a stack of time

 

[Ken Snell \(MVP\)]

See this site for info about the various arguments for the RunCommand
method:
http://www.tkwickenden.clara.net/