> > Here's an odd one. The following code returns two different answers, even > though they should be identical: > > **************** > * The following code makes vp_dbfname = "" > **************** > iif(EMPTY(thisform.ctextbox1.Value),vp_dbfname = "", ; > vp_dbfname = thisform.ctextbox1.Value) > > **************** > * This code makes vp_dbfname = thisform.ctextbox1.Value > **************** > if EMPTY(thisform.ctextbox1.Value) > vp_dbfname="" > else > vp_dbfname = thisform.ctextbox1.Value > endif Try: vp_DbfName= iif( empty(thisForm.cTextBox1.value), ; '', thisForm.cTextBox1.value ) Or even better: vp_DbfName= thisForm.cTextBox1.value Regards, Biju