post an example of Status so we know what we're dealing with.
Me.Dirty=True
Windows 11 
Office 365
post an example of Status so we know what we're dealing with.
If this helped, please click the star * at the bottom left and add to my reputation- Thanks
Virtually Inert Person
Windows 10 Access 2016
Status is not a reserved word.
No, Nz does not convert null, it returns an alternate value of your choice via the "value if null" parameter. If you don't specify the "value if null" parameter I believe you get a variant that contains an empty string. Not sure.
I can't think of any conversion functions (e.g. CDate) that will accept empty strings or nulls except maybe CStr. Nor will functions such as Left, AFAIK.
So validate what is being passed to any function on a line that raises an error. If they're nested, test the function expressions from the inside out.
Last edited by Micron; 10-18-2022 at 03:26 PM. Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Competent Performer
Windows 10 Access 2002
I didn't see where this was said but I ended up doing this if the value is a ZLS it jumps to the end of sub.Originally Posted by davegri
I am not sure if there is a better way to do this but I did it like so:
Maybe I can just replace the GoTo with End Sub. I will attempt it. Either way this issue is solved!Code:If (strStatus = "") Then GoTo LastLine LastLine: End Sub
VIP
Windows 10 Office 365
Just use
Much simpler!Code:If strstatus = "" Then Exit Sub
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Changing data type with linked file
Posting Permissions
Reply With Quote