To Zoom with SendKeys, Shift F2, use DoEvents

[sierra7]

Hi
I have often wanted to allow users to double-click on a control to open the Zoom window, instead of having to revert to the Shift +F2 keyboard method.

The command SendKeys "+{F2}" works for the On_Click event but not for Double_Click. You can open a message box but not the Zoom window!

However, I have found that by putting a DoEvents after the SendKeys, it works reliably.

Private Sub Narrative_DblClick(Cancel As Integer)
'MsgBox "Double Click detected"
SendKeys "+{F2}"
DoEvents
End Sub

This has bugged me for years so I was happy to find a fix.

Incidentally, I'm finding I need to put DoEvents in previously reliable code, after functions or calling procedures, to try and keep things synchronized. Whether this is because computers are faster or later versions of Access try multi-tasking, I don't know.

S7

[missinglinq]

You should never use SendKeys unless nothing else is available, which is not the case here!

Private Sub YourTextBox_DblClick()
  DoCmd.RunCommand acCmdZoomBox
End Sub

I have no idea on your DoEvents problem; never experienced it or read about it anywhere else. Perehaps your explanation is correct. What type of procedures are involved?

Linq ;0)>

[FishVal]

DoEvents passes control to the operating system. Control is returned after the operating system has finished processing the events in its queue and all keys in the SendKeys queue have been sent.

Quite straightforward I guess. The question is why it worked previously.

Regards,
Fish.

[missinglinq]

Of course, using Why and SendKeys in the same sentence has always been a pretty futile exercise! There's never really been any rhyme or reason as to what they do or don't do!

Linq ;0)>

[sierra7]

You should never use SendKeys unless nothing else is available, which is not the case here!

Private Sub YourTextBox_DblClick()
DoCmd.RunCommand acCmdZoomBox
End Sub

I have no idea on your DoEvents problem; never experienced it or read about it anywhere else. Perehaps your explanation is correct. What type of procedures are involved?

Linq ;0)>

Thanks for the comments guys! I thought that might get a response.

Thanks for the tip about acCmdZoomBox Linq. I failed to find that one! I agree totally about not using SendKeys and if this tests successfully, will swap at the next opportunity.

I haven't seen the Help topic refered to by Fish but originally used DoEvents to get other command buttons to respond while continuously looping to read data off COM1.

Since migrating a '97 project to 2003, one subform in particular showed #Error after a 'stock picking operation' when previously all was OK under '97. The system does things like;- find next next Invoice number; reduce quantity remaining on Batch, add quantity & BatchID to picked material; calculate and display profit. Nothing really difficult but requires steps to be performed in an orderly fashion. The text box for 'profit' showed #Error (which was disconcerting to the user!) although correct figures displayed on re-opening the form. Tried Refresh, Recalc, even Requery but found that DoEvents between the procedures worked. End of!

S7

[missinglinq]

DoEvents is always a good thing to try when you have muliple things running where some things may take a bit of time to complete. I've had to use it where a single button was used to print out multiple reports.

Still don't have a clue why you have to use it now when you didn't in ACC97. Never worked in 97. In every version since 2000 operations are asynchronous, but maybe that wasn't true in 97.

Linq ;0)>