Help with #error - NZ, Iserror, isnull not working

[gatefire08]

Hello,

I am stuck. I have been trying to figure out how to get rid of #error. I have uploaded the database.

When I open up the frmMail and then the qryLayout, I get #error. I know the reason why (because the textboxes on the form are blank or null.

How do I get the qrylayout to display a blank and get rid of #error.

I tried Nz function, IsError, Isnull, none of it worked.


Thank you so much for your help!

 

[JHB]

Here is the syntax for the [Last Name], let's if you can figure out for the [Password].

SELECT iif(Isnull([Forms]![frmMain]![txtStartPosition]),Null,Mid([Field1],[Forms]![frmMain]![txtStartPosition],[Forms]![frmMain]![txtLength])) AS [Last Name]
FROM tblProduction;

 

[gatefire08]

wow! thank you so much!!


SELECT iif(Isnull([Forms]![frmMain]![txtStartPosition1]),Null,Mid([Field1],[Forms]![frmMain]![txtStartPosition1],[Forms]![frmMain]![txtLength])) AS [Password]
FROM tblProduction;

=]