adewale4favour
Registered User.
- Local time
- Today, 12:36
- Joined
- Aug 9, 2019
- Messages
- 55
Hi guys,
Please I am faced with a little challenge in my Database especially from the Users Interface.
I have a form with few fields. One of those fields is a drop-down. The drop down does not allow users to type anything. You can only select from the drop down list from the combo box. But I noticed something, some users tried to beat-this-system of data-entry restrictions. What they simply do is (to avoid the drop-down selection, the copy what they want, which is an item not in the list. They copy what and use Ctrl+v to past this into the form). With this, they bypass the list item in the dropdown and paste their own choices.
What I have tried to do is
1. I tried to use the control of that form, from property sheet, the Data Tab (Allow Value list edit: NO, Limit to list: YES, Enabled: Yes, Locked: NO,) When i tried to put the Locked to YES, - it did not work, rather they wouldn't be able to select any thing from the drop-down.
I know there should be a way around this, but I can't figure it out yet. The data is completely messed up with this. I will appreciate contributions to kick out Paste Command from running on the form.
Many thanks
Michael
Please I am faced with a little challenge in my Database especially from the Users Interface.
I have a form with few fields. One of those fields is a drop-down. The drop down does not allow users to type anything. You can only select from the drop down list from the combo box. But I noticed something, some users tried to beat-this-system of data-entry restrictions. What they simply do is (to avoid the drop-down selection, the copy what they want, which is an item not in the list. They copy what and use Ctrl+v to past this into the form). With this, they bypass the list item in the dropdown and paste their own choices.
What I have tried to do is
1. I tried to use the control of that form, from property sheet, the Data Tab (Allow Value list edit: NO, Limit to list: YES, Enabled: Yes, Locked: NO,) When i tried to put the Locked to YES, - it did not work, rather they wouldn't be able to select any thing from the drop-down.
I know there should be a way around this, but I can't figure it out yet. The data is completely messed up with this. I will appreciate contributions to kick out Paste Command from running on the form.
Many thanks
Michael