Yes/No Field - convert Yes to Text On Report

[mjsearcy]

Hi all, thank you in advance for your help. I have a Yes/No Field titled "andfamily". What I am trying to do is, when the "Yes" field is clicked, that ", and family" will be added to the "Last Name" field on the report/labels. I have written code in the query that works, but I can not get it to work on the report. The query code is Expr1: IIf([andfamily]=True,", and Family ",""). The labels code without the ", and family" added is =([Salutation]+" ") & ([NameonEnvelope]+" ") & [Last Name]. The code on the label, which does not work is, =([Salutation]+" ") & ([NameonEnvelope]+"") & ([Last Name]+" ") & [IIf([andfamily]=True,",and Family " & [Last Name],"")]


Could someone please tell me what I am doing wrong. At this point, I am lost. Thank you so very much.

Maurita

[June7]

What do you mean by 'does not work' - error message, wrong results, nothing?

Don't use [] around the IIf expression.

[mjsearcy]

Thank you from the bottom of my heart, that did the trick. I have been working on this code for hours, but never got it to work. You are fantastic! Again, thank you.