Here's a fairly simple way I worked up, ages ago, to roll your own Zoombox. Place a large Textbox (call it MyZoomBox) on your Form. Format it as you like, making the Font larger, a different color, whatever, position it as you like and assign it the same Control Source as the Control you want to expand. Yes, a Form can have two Textboxes with the same Control Source!
Substitute the actual name of your Control to be expanded for YourTextBox, in the example.
Code:
Private Sub Form_Load()
'Make the Zoombox invisible on loading the form
MyZoomBox.Visible = False
End Sub
Code:
Private Sub YourTextBox_DblClick(Cancel As Integer)
'When you double click the field, make the MyZoomBox
'visible and move the cursor to the beginning to
'de-select the text
MyZoomBox.Visible = True
MyZoomBox.SetFocus
MyZoomBox.SelStart = 0
End Sub
Code:
Private Sub MyZoomBox_DblClick(Cancel As Integer)
'Double click the MyZoomBox to close it and
'return to your original field
Me.YourTextBox.SetFocus
MyZoomBox.Visible = False
End Sub
AS the comments indicate, you make the Zoombox visible by double-clicking the original Control you want expanded. Do whatever you want to the data, then double-click the Zoombox to close it.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007