In a report I’m displaying a checkbox with the data name being OwnSVF and the checkbox name being cbS. All I’m trying to do within the report is have the checkbox display only when it is equal to -1. I’ve tried variations similar to:
IIf ([OwnSVF] = -1), cbS.Visible = True, cbS.Visible = False
and was laughed at by Access. Any suggestions or am I barking up an unclimbable tree? Thanks in advance for any help.
![]() |
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 |
-
Checkboxes Again (A2K)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Checkboxes Again (A2K)
- This topic has 6 replies, 5 voices, and was last updated 23 years, 2 months ago.
AuthorTopicWSAGMCon
AskWoody LoungerMarch 4, 2002 at 4:54 am #367680Viewing 3 reply threadsAuthorReplies-
WSpatt
AskWoody Lounger -
WSBat17
AskWoody LoungerMarch 4, 2002 at 8:28 am #574042 -
WSAGMCon
AskWoody LoungerMarch 4, 2002 at 11:24 am #574062As always the friendly Woody loungers come through. I promise to be less cute and more clear in the future when airing out my Access problems. In this particular case, I had the right idea with respect to the code needed, but applied it in the wrong place. Thanks again to all of you folks who jumped in.
Andy
-
-
WSrhconley
AskWoody Lounger -
WSrory
AskWoody LoungerMarch 4, 2002 at 12:45 pm #574078Hi Andy,
Just for future reference, your original error was down to the way you were trying to use IIf. The IIf function returns a value, it doesn’t perform an action. You could have used it like this:
cbS.visible = iif([OwnSVF]=-1,True, False)
because that way the IIf function is returning either True or False, it’s not attempting to assign the value to anything. Otherwise, you have to use the If…Then..Else syntax suggested previously.
I hope that makes sense. -
WSAGMCon
AskWoody Lounger
-
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 well does your browser block trackers?
by
n0ads
16 minutes ago -
You can’t handle me
by
Susan Bradley
2 hours, 28 minutes ago -
Chrome Can Now Change Your Weak Passwords for You
by
Alex5723
27 minutes ago -
Microsoft: Over 394,000 Windows PCs infected by Lumma malware, affects Chrome..
by
Alex5723
7 hours, 50 minutes ago -
Signal vs Microsoft’s Recall ; By Default, Signal Doesn’t Recall
by
Alex5723
8 hours, 1 minute ago -
Internet Archive : This is where all of The Internet is stored
by
Alex5723
8 hours, 14 minutes ago -
iPhone 7 Plus and the iPhone 8 on Vantage list
by
Alex5723
8 hours, 19 minutes ago -
Lumma malware takedown
by
EyesOnWindows
15 hours, 33 minutes ago -
“kill switches” found in Chinese made power inverters
by
Alex5723
17 hours, 7 minutes ago -
Windows 11 – InControl vs pausing Windows updates
by
Kathy Stevens
17 hours, 1 minute ago -
Meet Gemini in Chrome
by
Alex5723
21 hours, 6 minutes ago -
DuckDuckGo’s Duck.ai added GPT-4o mini
by
Alex5723
21 hours, 15 minutes ago -
Trump signs Take It Down Act
by
Alex5723
1 day, 5 hours ago -
Do you have a maintenance window?
by
Susan Bradley
16 hours, 23 minutes ago -
Freshly discovered bug in OpenPGP.js undermines whole point of encrypted comms
by
Nibbled To Death By Ducks
7 hours, 26 minutes ago -
Cox Communications and Charter Communications to merge
by
not so anon
1 day, 8 hours ago -
Help with WD usb driver on Windows 11
by
Tex265
1 day, 13 hours ago -
hibernate activation
by
e_belmont
1 day, 17 hours ago -
Red Hat Enterprise Linux 10 with AI assistant
by
Alex5723
1 day, 21 hours ago -
Windows 11 Insider Preview build 26200.5603 released to DEV
by
joep517
2 days ago -
Windows 11 Insider Preview build 26120.4151 (24H2) released to BETA
by
joep517
2 days ago -
Fixing Windows 24H2 failed KB5058411 install
by
Alex5723
20 hours, 27 minutes ago -
Out of band for Windows 10
by
Susan Bradley
2 days, 5 hours ago -
Giving UniGetUi a test run.
by
RetiredGeek
2 days, 12 hours ago -
Windows 11 Insider Preview Build 26100.4188 (24H2) released to Release Preview
by
joep517
2 days, 19 hours ago -
Microsoft is now putting quantum encryption in Windows builds
by
Alex5723
15 hours, 27 minutes ago -
Auto Time Zone Adjustment
by
wadeer
3 days ago -
To download Win 11 Pro 23H2 ISO.
by
Eddieloh
2 days, 21 hours ago -
Manage your browsing experience with Edge
by
Mary Branscombe
2 hours, 51 minutes ago -
Fewer vulnerabilities, larger updates
by
Susan Bradley
17 minutes 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.