Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Form Help!
- Thread starter Caryisms
- Start date
Syntax: IIf («expr», «truepart», «falsepart»)
set control source of the textbox (this is off top of my head, so will probably need tweeking):
=Iif ([Field 1] = "Primary",[Field 2] & " " & [Field 3]," "
In this example it inserts a space if [Field 1] is not = "Primary"
Karl
set control source of the textbox (this is off top of my head, so will probably need tweeking):
=Iif ([Field 1] = "Primary",[Field 2] & " " & [Field 3]," "
In this example it inserts a space if [Field 1] is not = "Primary"
Karl
- Status
