Access: no copy & paste in Zoom Window

[Mon Ange]

Hi everyone,

Although I do have some experience with Access I encounter a problem, which I could not solve yet.
All search on the net did not bring up any result either, so I hope that someone in here can help me out.

When using Access 2003 I can't use copy & paste shortcuts in the zoom window of any property dialog. The context menu does not show up either.
Can anyone tell me how tosolve this issue?
Thanks a lot in advance

[missinglinq]

I developed this routine a while back for someone who was having trouble with the standard Zoom command. Since in essence it uses a standard textbox, you should be able to do anything with it that you do with any textbox.

Place a large text box (call it Zoombox) on your form. Assign it the same Control Source as the field you want to expand, and make it visible by double clicking the field you want expanded.

Substitute the actual name of your field to be expanded for YourFieldName.

Private Sub Form_Load()       'Make the textbox invisible on loading the form    
  Zoombox.Visible = False
End Sub

Private Sub YourTextBox_DblClick(Cancel As Integer) 'When you double click the field, make the ZoomBox visible and move the 'cursor to the beginning to deselect the text 
  Zoombox.Visible = True
  Zoombox.SetFocus    
  Zoombox.SelStart = 0
End Sub

Private Sub Zoombox_DblClick(Cancel As Integer) 'Double click the ZoomBox to close it and return to your original field
 
 Me.YourTextBox.SetFocus
 Zoombox.Visible = False
End Sub

Post back if you have any problems!

Welcome to TheScripts!

Linq ;0)>

[Mon Ange]

Thanks a lot for the quick answer,
but my problem does not occur when in "runtime mode".
I do have this problem in design mode.
I was wondering if there are any "hidden" settings in Access, which can cause that the transfer of data via the clipboard does not work.

[wvmitchell]

Are you saying that the standard Windows shortcut keys like Ctrl-C for copy, Ctrl-V for paste, Ctrl-X for cut, are not working for you?

That has happened to me sometimes during an extended session using Remote Desktop to connect to the design. But not when working on a local machine. I think it had something to do with Windows resources, is it possible that you are running out of GDI memory due to too many background programs or processes?

[missinglinq]

Sorry, your talk of Zoom boxes confused me. If My Angel's take on the problem is correct, the answer put forth is probable also true. This problem comes up on a regular basis, although it usually involves trying to copy data from one place for transfer to another. The best answer anyone has ever come up with is that it is, indeed, a question of system resources, with memory apparently not being released after each C & P.

This answer is almost always backed up by the fact that:

1. As Angel suggested, it usually occurs after extended seesions, where Copy & Paste has been used often.
2. If the user goes into another Office program, such as MS Word, and tries to perform Copy & Paste, it also fails.
3. If the user exits Access and reboots the PC, the problem miraculously resolves itself.

Linq ;0)>

[Mon Ange]

Thank you very much for your hints.

I'm going to survey this behavior for a little while and see if there is a connection with a lack of system ressources.

Again, thanks a lot