ok im having trouble with my imput box it crashes when i enter text, nothin and when i press the cancel button. i do realise when i click the cancel buttin it returns a null value and vb doesnt like it but why does it crash with letters or typing nothin because i have put if it = "" then.... shouldnt that mean it will accept nothin entered?
heres one of the input boxes maybe u can tell what im doin wrong and how to fix it.
The code looks clean to me and according to me it works if you write
If Q = ""
Did you try debugging?
Does it crash at this statement?
You can try using vbNull or just NULL, whichever works correctly.
ElseIf Q = vbNull Then
ElseIf Q = Null Then
Let me know the outcome.
i got a reply on another forum and that way seems to have worked perfect plus made the code alot shorter but thanks for your reply :)
|All times are GMT +5.5. The time now is 17:02.|