Jul 16 2008, 04:47 PM
I have several bound text box controls that display data, but are not supposed to be changeable. Originally, they were Not Enabled, which functionally worked fine. But the users complained that the greyed out effect was not very readable(fuzzy). So, I changed the properties to locked and enabled. This enabled me to use a color like greyed out, but the displayed text was much more readable. The problem is that the use can click and set focus in those fields, and then if they scroll with their mouse, they can scroll through records when they are not supposed to. I looking for a way to prevent the scrolling. Better would be disabling the controls with a way to make it more readable. Any ideas?
Jul 16 2008, 05:07 PM
I am not sure that making all the controls locked or nor enabled would prevent a user from scrolling through records.
You could try either
1. Opening the form filtered to the required record
DoCmd.OpenForm "YourFormName",,, "TableID=" & RecordIDNo
2. Use a subform
3. Use the form filter
Me.Filter = "TableID=" & RecordIDNo
Also ensure that the form's allow additions property is set to No.
If the form is meant to be read only, then you can set the forms Allow deletions and allow
edits properties to No as well.
Edited by: pere_de_chipstick on Wed Jul 16 18:09:20 EDT 2008.
Jul 16 2008, 05:33 PM
Is the forms "Cycle" property set to "All Records" if so change it to "Current Record" and see if that helps..
Jul 16 2008, 05:47 PM
H. Jackson Brown,
Thanks, so much. That solved my problem. Harry
Jul 16 2008, 05:48 PM
One more time. The other suggestion I received to set the form cycle property to 'current record' solved the problem. Thanks again, Harry
Jul 16 2008, 06:00 PM
Glad it worked for you..
By the way.. the letters HTH mean "Hope that helps"
Jul 16 2008, 06:14 PM
Glad Larry's suggestion worked.
Though I am a bit surprised, setting the "Cycle" property to "Current Record" will stop the TAB key from moving the focus to another record but will not stop the mouse scroll wheel from moving to another record.
Anyway - if it solved your problem, all's well and good.
Jul 17 2008, 02:27 AM
It was just a thought as I'd never tested it before..
Jul 17 2008, 03:04 AM
No Problem Larry
The OP seems happy - you obviously interpreted his post better than me!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here