Expression Builder Blues

[justphilip2003]

I do not seem to be able to code selective code, for example

=[FName]& " " & [LName] works beautifully but

=[Iff sex=”M”,”Mr. & “, “Ms. & “ [FName] & " " & [LName]] gives me an invalid expression syntax error. I've tried all sorts of variations like



=[Iff sex =”M”,”Mr “, “Ms“] & ". " & [FName] & " " & [LName]] with similar errors.

I have similar bad results with Choose and Switch functions. Is there a trick involve that I am not aware of? TIA Phil

[boblarson]

It would help if you had the right function name and parens, etc.

=[Iff sex=”M”,”Mr. & “, “Ms. & “ [FName] & " " & [LName]]

SHOULD BE

=IIf([sex]=”M”,”Mr. “, “Ms. “) & [FName] & " " & [LName]

[rzw0wr]

try,
iif([sex]="M", "Mr." & [FName], "Ms." & [FName])

EDIT: just noticed that Bob's post beat mine.
Bob's answer is more correct than mine.
I was giving an example of the iif() function, his gives a complete answer.

Dale

[justphilip2003]

Gentlemen I used Bob's code and I get a little window asking for the Parameter value of "M". I am stumped! Phil

[justphilip2003]

Could there be an Property field that needs addressing besides the control source? TIA Phil

[boblarson]

Gentlemen I used Bob's code and I get a little window asking for the Parameter value of "M". I am stumped! Phil

Are you sure that the control or field name is named sex? Do you actually have that field in the form's control source and is it bound to a control on the form?

[justphilip2003]

I'm afraid it is. This db is about code and functionally not pretty or meaningful data; I threw in fields that were easy (I thought) to test. The Form ButtonMania has every possible button I could think of and data manipulation, in this case an unbound field using bound fields to populate the unbounded text box. Also, I corrected the code. Small print is difficult for me to see. =Iff([Sex]="M", "Mr. ", "Ms. ") & [FName] & " " & [LName]. Still when I try to save this code, I get a syntax error. TIA Phil

[pbaldy]

As was pointed out earlier, it's IIf not Iff.

[boblarson]

As was pointed out earlier, it's IIf not Iff.

^^^^^^^^^^^^^^ + 1 ^^^^^^^^^^^^^^^^^