This has been bugging me for time, now.
At the moment, I need to check whether a couple of combo boxes & a few text boxes have values. I have tried the follwing:
If txtName=Null Then...
If txtName="" Then...
If Len(txtName) < 1 Then...
If Not txtName Then...
Nothing works! I test everything I can think of, and at no time can I get the code to recognise that a control is blank!
Please can someone show me where I'm going hideously astray before I embark on a life as a serial killer!
Douglas JL. If it don't make you laugh, it ain't true.
At the moment, I need to check whether a couple of combo boxes & a few text boxes have values. I have tried the follwing:
If txtName=Null Then...
If txtName="" Then...
If Len(txtName) < 1 Then...
If Not txtName Then...
Nothing works! I test everything I can think of, and at no time can I get the code to recognise that a control is blank!
Please can someone show me where I'm going hideously astray before I embark on a life as a serial killer!
Douglas JL. If it don't make you laugh, it ain't true.