Re: =Iff(([Me]![Gender])="M","Male","Female")

When you say it doesn't work, do you mean the visible text box is
empty? Or, does it display an error?

Out of curiousity, why are you using two text boxes? I think it might
be simpler to use a single combo box. Make its properties like so:

Control Source: Gender
Row Source Type: Value List
Row Source: "M";"Male";"F";"Female"
Column Count: 2
Column Heads: No
Column Widths: 0"
Bound Column: 1

This will give you a drop down list with two rows. Since the Column
Count is 2, the "M" and "Male" values are the two columns for the first
row and the "F" and "Female" are the two columns for the second row.
Setting the Column Width to 0" means the first column will not be
displayed but since it's the Bound Column, the "M" and "F" will be used
as the value of the Gender field. Hope this makes sense.

.

Relevant Pages

  • Refresh nested subforms
    ... Display Control: Combo Box ... Row Source Type: Table/Query ... Row Source: SELECT CountryCodes.CountryName FROM CountryCodes ORDER BY ... This field joins the tables using the destination name ...
    (microsoft.public.access.formscoding)
  • RE: Display Yes/No instead of -1, 0 on Search Forms
    ... Row Source Type: Value List ... Bound Column: 1 ... To get Yes/No to display in your query, ... 'Set the WHERE clause for the Listbox RowSource if information has been ...
    (microsoft.public.access.formscoding)
  • Re: Dont allow select in combo box
    ... Row Source Type: Table/Query ... Display When: Always ... Tab Stop: Yes ... > The Locked property may be set to Yes. ...
    (microsoft.public.access.forms)