Isladogs, my version of A2007 doesn't contain the "Microsoft Forms 2.0 Object Library". Is what it does contain in another library or what?
Using you your code (above), when I insert 'ClearClipboard' in a control's VBA and run that code, I get a message saying "Expected variable or procedure, not a module". I get that using 'Call Clearclipboard', clearclipboard() and Clearclipboard(08).
Using this - DoCmd.OpenModule "ClearClipboard", "ClearClipboard" - opens the module and places the cursor before 'OpenClipboard (0&) or 'OpenClipboard() or 'OpbeClipboard', whichever of those that I try).
Do I need a 'run command' statement or how do I get what I want to happen?
Also, while the A2007 clipboard window is open and contains 'items' in it, are the items erased from the window, like when I clear the clipboard manually, and, if they are cleared by the VBA, is the clipboard actually cleared, anyway & how can I see that it is clear. (F8ing in the module to the sub's end, to 'run' the sub, then, closing and reopening the clipboard window still shows the items in it.??