David McAfee
dmcafee at pacbell.net
Mon Nov 14 13:39:39 CST 2005
The event that I mentioned isn't a form event, it is a control event. In design mode, you have to click on the text box in question, then choose properties (either by clicking on the tool bar icon which looks like a finger pointing at a paper. or by right clicking on the control and choosing properties. With the code that I just sent you (OnChange event), you dont have to worry about the clip board, it warns you that too many characters have been entered and then it truncates the text to 75 characters. David -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tony Septav Sent: Monday, November 14, 2005 11:12 AM To: accessd at databaseadvisors.com Subject: [AccessD] Trap for Error Hey All Thanks again. But I could not trap (and I don't think you can, using the form control events) for the Paste from clipboard error " "The text is too long to be edited". So I trap for it on the on keydown event for the text box. ClipBoard_GetData() = Is a function (not mine) that will allow you to get the text currently stored in the clipboard. Hope this may be of use to others.