Expanding and Collapsing

[magmike]

I am working with a continuous form that shows "note" entries related
to a company record. The goal is to list entries sorted by date, only
showing the first line of the note entry and using a button or image
or something to click on to expand that particular note record. Any
help would be appreciated in how to do this.

Thanks in advance!
magmike

 

[John Spencer]

You can type Shift+F2 to Zoom the current control.

You can add a button that sets the focus to the Note control and then does the
zoombox.

Private Sub btnZoom_Click()
Me.txtShowDetails.SetFocus
DoCmd.RunCommand acCmdZoomBox
End Sub

If you don't like the built-in zoombox feature, then you can
-- Build a custom form with a control to display the note and a close button
to close the form. If you want to edit the contents you are going to have to
add code to save any changes on the main form before you open the custom form.
-- Open it in dialog mode, passing it an argument to tell it which note to
display.


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