Re: [MS_AccessPros] Old Timer's Disease again

 

Robin,

Are you certain Exclude is a yes/no field? 

   If Exclude is a text field and not a yes/no, you will get the #Type! error

Is it possible some values might be Null?

What exactly is your control source?

Duane

---

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 11:39 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Old Timer's Disease again

 

Thanks Duane,

I named the control "ExcludeR" and I get this: #Type!

Regards,

Robin

At 14/09/2017 11:55 AM, you wrote:

 

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
 

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/

Yahoo! Groups groups.yahoo.com /

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/MS_Access_Professionals/join

Yahoo! Groups groups.yahoo.com /

Yahoo! Groups 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 (5)

---

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.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___