Why does the Zoom dialog box open every time I click on a drop-down?

[RockandGrohl]

Hi, I'm a novice at Access and just using a form someone else has made.

One of the pages in form view has a series of drop-down boxes which you can click on to insert a pre-written field.

Every time you click on one, it opens a "Zoom" dialog window, which I then have to close. This is just an annoying behaviour, but the person who made it doesn't know why it happens or how to stop it. Hoping someone here does!

It's this thing:

Use the zoom box to enter text and expressions - Microsoft Support

Use the zoom box to enter text and expressions in a property sheet or Query Design view.

support.microsoft.com

Thanks!

 

[jackd]

Suggest you do some debugging to determine details. Since shift +F2 is default to open Zoom box, there may be some vba in one of your procedures that is spawning this behaviour.

 

[RockandGrohl]

Suggest you do some debugging to determine details. Since shift +F2 is default to open Zoom box, there may be some vba in one of your procedures that is spawning this behaviour.

I'm new to how VBA & access interact, these are the drop down boxes that spawn the zoom box when clicked on (each one will spawn the zoom box, only once)

How do I find the VBA that controls these dropdown boxes? In Excel it would be embedded in a UserForm and I'd go from there. Not sure about here though.



EDIT: Used my brain and found it. Here's the code.

Option Compare Database

Private Sub BtnCLose_Click()
DoCmd.Close
End Sub

Private Sub Resolution_Note__BeforeUpdate(Cancel As Integer)
Me.Query_Resolved_ = True
Me.Resolution_Date_ = Now()
End Sub

Private Sub Resolution_Note__GotFocus()
DoCmd.RunCommand acCmdZoomBox
End Sub

Private Sub Text32_GotFocus()
DoCmd.RunCommand acCmdZoomBox
End Sub

Considering my colleague said he didn't know why the zoom box was appearing, that looks like pretty obvious behaviour to me. Do you know any reason why this would be added? Like is there some dependency I'm not aware of? I suppose I can just comment out the line and see what happens..

 

[RockandGrohl]

Commented it out. Problem solved.

 

[jackd]

See this Debugging vba material from Chip Pearson.
If you prefer video see this by Steve Bishop