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
-
How reliable is Flighys in booking international flights? (Awaiting moderation)
by
flighys126
1 minute ago -
Suggestions for New All in One Printer and a Photo Printer Windows 10
by
Win7and10
3 hours, 7 minutes ago -
Purchasing New Printer. Uninstall old Printer Software First?
by
Win7and10
3 hours, 11 minutes ago -
KB5060842 Issue (Minor)
by
AC641
7 hours, 44 minutes ago -
EchoLeak : Zero Click M365 Copilot leak sensitive information
by
Alex5723
10 hours, 16 minutes ago -
24H2 may not be offered June updates
by
Susan Bradley
4 hours, 44 minutes ago -
Acronis : Tracking Chaos RAT’s evolution (Windows, Linux)
by
Alex5723
22 hours, 50 minutes ago -
Turning off OneDrive
by
CWBillow
1 day, 3 hours ago -
June 2025 updates are out
by
Susan Bradley
6 hours, 10 minutes ago -
Mozilla shutting Deep Fake Detector
by
Alex5723
1 day, 13 hours ago -
Windows-Maintenance-Tool (.bat)
by
Alex5723
22 hours, 59 minutes ago -
Windows 11 Insider Preview build 26200.5641 released to DEV
by
joep517
1 day, 16 hours ago -
Windows 11 Insider Preview build 26120.4250 (24H2) released to BETA
by
joep517
1 day, 16 hours ago -
Install Office 365 Outlook classic on new Win11 machine
by
WSrcull999
1 day, 16 hours ago -
win 10 to win 11 with cpu/mb replacement
by
aquatarkus
1 day, 8 hours ago -
re-install Windows Security
by
CWBillow
1 day, 19 hours ago -
WWDC 2025 Recap: All of Apple’s NEW Features in 10 Minutes!
by
Alex5723
1 day, 23 hours ago -
macOS Tahoe 26
by
Alex5723
1 day, 17 hours ago -
Migrating from win10 to win11, instructions coming?
by
astro46
4 hours, 27 minutes ago -
Device Eligibility for Apple 2026 Operating Systems due this Fall
by
PKCano
1 day, 7 hours ago -
Recommended watching : Mountainhead movie
by
Alex5723
1 day, 8 hours ago -
End of support for Windows 10
by
Old enough to know better
16 hours, 7 minutes ago -
What goes on inside an LLM
by
Michael Covington
1 day, 2 hours ago -
The risk of remote access
by
Susan Bradley
9 hours, 58 minutes ago -
The cruelest month for many Office users
by
Peter Deegan
10 hours, 36 minutes ago -
Tracking protection and trade-offs in Edge
by
Mary Branscombe
1 day, 12 hours ago -
Supreme Court grants DOGE access to confidential Social Security records
by
Alex5723
2 days, 21 hours ago -
EaseUS Partition Master free 19.6
by
Alex5723
1 day, 22 hours ago -
Microsoft : Edge is better than Chrome
by
Alex5723
3 days, 10 hours ago -
The EU launched DNS4EU
by
Alex5723
3 days, 23 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.