textbux in raport helpppppppppppppppppppp

  • Thread starter Thread starter asyyyya
  • Start date Start date
A

asyyyya

hy
i have a problem
from a client tabel with the following fields:nume(text) , genre(text).i want
to make a report to write in a textbox miss or mister ;depending on the field
"genre"-male or female
 
In the control source for an unbound text box:
=IIf([genre] = "male","Mr.","Miss")
or you could combine things:
=IIf([genre] = "male","Mr. ","Miss ") & [FirstName] & " " & [LastName]
 
Back
Top