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


<campbellbrian2001@xxxxxxxxx> wrote in message
news:1135971912.609537.50620@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I just want two display "Male" in my textbox if the value in the table
> is "M".
>


Brian, I don't think you need two textboxes. Assuming Gender is the field
name and is required, set the control source to:

IIf([Gender]="M", "Male", "Female")


--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

.

Relevant Pages

  • RE: search for file path, please help
    ... "ListBox1" is populated with every file in that sub-directory. ... in the BkLocation textbox. ... The BkLocation text box would display something like ...
    (microsoft.public.access.formscoding)
  • RE: search for file path, please help
    ... "ListBox1" is populated with every file in that sub-directory. ... in the BkLocation textbox. ... The BkLocation text box would display something like ...
    (microsoft.public.access.formscoding)
  • RE: How to lookup the corresponding field?
    ... But I was hoping to use the Category textbox still ... because I just want it to display the value, and not to give user the choice ... > tblType need only a numeric field in which to store the ID, ... >> But the CategoryID textbox in frmType still displays CategoryID values, ...
    (microsoft.public.access.forms)
  • RE: search for file path, please help
    ... "ListBox1" is populated with every file in that sub-directory. ... in the BkLocation textbox. ... The BkLocation text box would display something like ...
    (microsoft.public.access.formscoding)
  • Re: Automatically Populate Field
    ... If the dropdown includes the Project Number, you can refer to and display it ... in a textbox by creating an unbound textbox and making it's source be: ... OnChange of the dropdown, ... use of a form where an employee selects the project name from a drop down ...
    (microsoft.public.access.forms)