Form Field

  • Thread starter Thread starter Gary Mann
  • Start date Start date
G

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
 
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.
 
Back
Top