Form Field

[Gary Mann]

Hi.
I have a form with the field [Sex] witch returns M or F.
I would like it displayed as Male or Female, simple I know. But it's been
along time since I last looked at Access and I thought this wouldn't be a
problem!!!.
I replaced the [Sex] field with the expression
=IIf([Sex]="M","Male"," Female") and
=IIf([Sex]=("M"),"Male"," Female")and
=IIf([Sex]=["M"],"Male"," Female")and
=IIf([Sex]='M',"Male"," Female") and as many other variations I can think
off.
Please can somebody help me, It' doing my head in.
Regards Gary

 

[Duane Hookom]

The first expression should work. It would really help if you told us what
your result was. I expect that your control name is "Sex". Rename it to
txtSex.