I have a form where I am calculating two fields and the rest are user entry fields. I want to keep the calculated fields as view only fields that the user can not access. I have the calculated fields set as Enabled = No and Locked = Yes. The first field that is a pure calculation
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Disabling fields on forms (Access 2003)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Disabling fields on forms (Access 2003)
- This topic has 17 replies, 6 voices, and was last updated 19 years, 4 months ago.
Viewing 3 reply threadsAuthorReplies-
WSSteveH
AskWoody Lounger -
WSHansV
AskWoody Lounger -
WSDouglas Martin
AskWoody LoungerFebruary 3, 2006 at 3:03 pm #998218I agree with HansV – sounds to me like you have the Locked property set to Yes, but somehow you neglected to set the Enabled property to No. I don’t believe SteveH’s suggestion of turning off the Tab stop property will make any difference – my databases have lots of locked fields, some permanently locked and some locked and unlocked in code, and I don’t think I have ever played with the Tab stop property – if a field isn’t enabled there’s no way you can tab to it.
-
WSjwink
AskWoody LoungerFebruary 3, 2006 at 4:14 pm #998233I had missed the tab stop setting and setting it as suggested corrects the issue with landing on the field when tabbing or hitting enter. I can still click on the field and access the field enough that it displays the underlying numeric value instead of the Yes, No value. Interestingly if I leave the settings as Enabled = No, Locked = Yes and Tab Stop = Yes like the first field that is working correctly and just change the source to the same calculated value as the first field, then the second field also works just like the first field. If I put the Iif code back in it goes back to being accessible. The Iif statement seems to be a contributing factor
-
WSHansV
AskWoody Lounger -
WSpatt
AskWoody Lounger -
WSHansV
AskWoody Lounger -
WSpatt
AskWoody Lounger -
WSHansV
AskWoody LoungerFebruary 3, 2006 at 9:04 pm #998289 -
WSpatt
AskWoody Lounger -
WSHansV
AskWoody Lounger -
WSpatt
AskWoody LoungerFebruary 3, 2006 at 9:31 pm #998294It’s ok, I found it in post 535990, thank you.
-
WSpatt
AskWoody Lounger -
WSHansV
AskWoody LoungerFebruary 3, 2006 at 11:31 pm #998306 -
WSpatt
AskWoody LoungerFebruary 3, 2006 at 11:45 pm #998307This form is a modification of a terrible form in a database that I inherited. If I try to create a control at the moment it shows 708 as the number of the text box it is creating. The maximum number of controls in a form is 754 as you said in an earlier post.
I might have to recreate the form as you said.
-
-
WScharlotte
AskWoody Lounger -
WSpatt
AskWoody LoungerFebruary 4, 2006 at 4:46 am #998323Good call Charlotte.
I had forgotten that depending on the User I either Enable or Disable all controls on the form except command buttons. This must be the problem, I will prove it by using Debug.Print to see if the control is enabled. It was enabling it.
Thanks again Charlotte for making me go open my eyes.
I think I will leave the OnGotFocus code that forces the user back to the previous control. I have changed it to disable the 2 controls and delete the OnGotFocus code.
-
-
-
-
Viewing 3 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Is AI Becoming Too Easy to Trust? Where Should We Draw the Line? (Awaiting moderation)
by
Samuel Miz
54 minutes ago -
Is Microsoft Copilot becoming a security risk for sensitive enterprise data? (Awaiting moderation)
by
Samuel Miz
1 hour ago -
How to get Microsoft Defender to honor Group Policy Setting
by
Ralph
3 hours, 23 minutes ago -
Apple : Paragon’s iOS Mercenary Spyware Finds Journalists Target
by
Alex5723
4 hours, 2 minutes ago -
Music : The Rose Room – It’s Been A Long, Long Time album
by
Alex5723
5 hours, 8 minutes ago -
Disengage Bitlocker
by
CWBillow
6 hours, 32 minutes ago -
Mac Mini M2 Service Program for No Power Issue
by
Alex5723
7 hours, 8 minutes ago -
New Win 11 Pro Geekom Setup questions
by
Deo
8 hours, 52 minutes ago -
Windows 11 Insider Preview build 26200.5651 released to DEV
by
joep517
14 hours, 23 minutes ago -
Windows 11 Insider Preview build 26120.4441 (24H2) released to BETA
by
joep517
14 hours, 25 minutes ago -
iOS 26,, MacOS 26 : Create your own AI chatbot
by
Alex5723
18 hours, 20 minutes ago -
New PC transfer program recommendations?
by
DaveBoston
41 minutes ago -
Windows 11 Insider Preview Build 22631.5545 (23H2) released to Release Preview
by
joep517
22 hours, 24 minutes ago -
Windows 10 Build 19045.6029 (22H2) to Release Preview Channel
by
joep517
22 hours, 26 minutes ago -
Best tools for upgrading a Windows 10 to an 11
by
Susan Bradley
10 hours, 45 minutes ago -
The end of Windows 10 is approaching, consider Linux and LibreOffice
by
Alex5723
8 hours, 7 minutes ago -
Extended Windows Built-in Disk Cleanup Utility
by
bbearren
19 minutes ago -
Win 11 24H2 June 2025 Update breaks WIFI
by
dportenlanger
1 day, 17 hours ago -
Update from WinPro 10 v. 1511 on T460p?
by
CatoRenasci
15 hours, 18 minutes ago -
System Restore and Updates Paused
by
veteran
1 day, 19 hours ago -
Windows 10/11 clock app
by
Kathy Stevens
1 day, 7 hours ago -
Turn off right-click draw
by
Charles Billow
1 day, 23 hours ago -
Introducing ChromeOS M137 to The Stable Channel
by
Alex5723
2 days, 2 hours ago -
Brian Wilson (The Beach Boys) R.I.P
by
Alex5723
20 hours, 33 minutes ago -
Master patch listing for June 10, 2025
by
Susan Bradley
2 days, 4 hours ago -
Suggestions for New All in One Printer and a Photo Printer Windows 10
by
Win7and10
1 day, 7 hours ago -
Purchasing New Printer. Uninstall old Printer Software First?
by
Win7and10
2 days, 10 hours ago -
KB5060842 Issue (Minor)
by
AC641
22 hours, 24 minutes ago -
EchoLeak : Zero Click M365 Copilot leak sensitive information
by
Alex5723
2 days, 17 hours ago -
24H2 may not be offered June updates
by
Susan Bradley
1 day, 10 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.