Robin,
If I understand correctly you should be able to set the control source to:
=IIf([Exclude] =True, "Exclude","")
Make sure the name of the control is NOT exclude.
I could be wrong if you are attempting to filter the records based on the value of Exclude or something else. "need a field content for" doesn't make much sense to me.
Regards,
Duane Hookom
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, September 13, 2017 8:11 PM
To: MS Access Professionals-yahoogroups.com
Subject: [MS_AccessPros] Old Timer's Disease again
Sent: Wednesday, September 13, 2017 8:11 PM
To: MS Access Professionals-yahoogroups.com
Subject: [MS_AccessPros] Old Timer's Disease again
I have a report with a Yes/No field called 'exclude'. I only need a
field content for the "Yes" option. I have tried this:
Iif [Exclude] = false, "Exclude", " "
which fails. What have I forgotten? BTW I am 87!
Robin Chapple
------------------------------------
Posted by: Robin Chapple <robinski@westnet.com.au>
------------------------------------
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
 | groups.yahoo.com / | |
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar