textbux in raport helpppppppppppppppppppp

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
 
B

BruceM

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]
 
Top