Prevent Copy & Paste in Access Forms
Although copy & paste is a standard feature in all Windows programs, there may be occasions when you want to prevent their use in an Access database. For example to prevent insertion of too many text characters from an external source into memo (long text) fields.
The video demonstrates how to prevent the following methods of copying & pasting data:
1. Using the right click context menu
2. Using keyboard shortcuts Ctrl+C & Ctrl+V
3. Using the ribbon
4. Direct data entry into tables
The example database is available at https://isladogs.co.uk/dl/StopCopyPas...
TIMES:
0:00 Intro
0:15 Why block copy & paste?
0:55 Example - student report character limit
1:34 Ways of pasting text that need to be blocked
2:17 Example database to demonstrate approach
2:44 Latin boiler plate pasted using keyboard shortcut
2:55 Use of context menu
3:03 Use of ribbon menu
3:09 Text directly pasted into table
3:32 Remove context menu - set shortcut menu property to No
3:55 Block keyboard shortcuts - set Key Preview property to Yes
4:39 ... and add code to Form KeyDown event
5:40 KeyDown code in use
6:15 Use of code to hide navigation pane & ribbon
7:00 Compact database to restart it - navigation pane & ribbon removed
7:23 Summary
8:23 Thanks..please like/comment/subscribe...