=Iff(([Me]![Gender])="M","Male","F emale")

[campbellbrian2001]

Thanks in Advance! ... I have two textboxes: 1 is visible (and gets its
value based on the invisible textbox and displays either "Male" or
"Female", and needs to display either male of female based on the value
that comes up in the tables record as "M" or "F".
I tried:

=Iff(([Me]![Gender])="M","Male","F emale")

'the [Me] is form, [Gender] is the textbox name

and this does not work.

Is my syntax wrong or can I just have one box and its displayed value
display "Female" if the record says "F"?
Thanks! Brian

[David W. Fenton]

fredg <fg******@examp le.invalid> wrote in
news:1h******** *************** ********@40tude .net:

Let's keep this thread on the subject of what would work for the
poster, not what may or may not be politically correct from your
view point (or from mine).

My opinion is that your suggestion was logically incorrect and
politically problematic.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Lauren Wilson]

I'm sure you got your answer by now so I won't weigh in on that. I'm
just a little sadder in seeing the nomenclature you use. Misuse of
language is a classic sign of disrespect for it. Disrespect for
language is a classic sign of cultural decay. Why did you not just
call the object "Sex"? Sex is easier to read, say and type than
Gender. People don't have gender. Only words have gender. If you
refer to the male or female property of a human, you are referring to
sex, not gender.
On 30 Dec 2005 11:23:17 -0800, ca************* **@yahoo.com wrote:

Thanks in Advance! ... I have two textboxes: 1 is visible (and gets its
value based on the invisible textbox and displays either "Male" or
"Female", and needs to display either male of female based on the value
that comes up in the tables record as "M" or "F".
I tried:

=Iff(([Me]![Gender])="M","Male","F emale")

'the [Me] is form, [Gender] is the textbox name

and this does not work.

Is my syntax wrong or can I just have one box and its displayed value
display "Female" if the record says "F"?
Thanks! Brian

[Lyle Fairfield]

A champion of Fowler's (Modern) English Usage is a joy forever.