>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
what you are returning from the code on top is the logical value of the expression vp_dbfname = ...
you should write instead :
vp_dbfname = IIF(EMPTY(thisform.ctextbox1.Value),"",thisform.ctextbox1.Value)
hoping this helps
Christian
Christian Desbourse ( Belgium )