[AccessD] Trap for Error

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.