Double-Click a Text Box to Open Larger on Screen

M

Maurita

Hi everyone, hope my request is doable in Access. I need to take a
text box on a form, double-click it, and then have the same text box
open larger on the screen so that the user can type into it. My users
have seen pop up boxes where they can type in info on other programs,
so they want this same feature in Access.

Thank you for your help in this matter.

Maurita Searcy
 
R

Rick Brandt

Maurita said:
Hi everyone, hope my request is doable in Access. I need to take a
text box on a form, double-click it, and then have the same text box
open larger on the screen so that the user can type into it. My users
have seen pop up boxes where they can type in info on other programs,
so they want this same feature in Access.

Thank you for your help in this matter.

Maurita Searcy
Click to expand...

Without any work by you at all they can simply press <Shift F2> and the zoom box
built into Access will open. This works on any TextBox.

If you *really* want it to happen on Double-Click you can use code...

DoCmd.RunCommand acCmdZoomBox

....in the control's Double-Click event.
 
B

Boyd Trimmell aka HiTechCoach via AccessMonster.co

Access has a built-in Zoom Box to do what you want. In any control press
Shift-F2.

You coudl also use the double click event like this example:

Private Sub Address_DblClick(Cancel As Integer)

DoCmd.RunCommand acCmdZoomBox


End Sub
 
M

Maurita

Access has a built-in Zoom Box to do what you want. In any control press
Shift-F2.

You coudl also use the double click event like this example:

Private Sub Address_DblClick(Cancel As Integer)

DoCmd.RunCommand acCmdZoomBox

End Sub




--
Boyd Trimmell
aka HiTechCoachhttp://www.hitechcoach.comhttp://www.officeprogramming.com

http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200712/1
Click to expand...

Thank you so very much for all your help. The code worked perfectly,
and I have learned something new, again. I appreciate your quick
response.

Maurita
 
B

Boyd Trimmell aka HiTechCoach via AccessMonster.co

Top