Hide error in textbox

[ikzouhetnietweten]

I'm pretty sure they mostly just wanted you to disclose that you cross posted this. That issue aside, if you are expecting free help on a technical issue, you should treat these volunteers with a bit more respect.

I know I crossposted a question, I' m the one crossposting it. A bit weird to reply as: ' double/cross posting, see my website'. Don't see the point. Then just don't reply, get over it and move on but ok.

I tried Nz( that's the code if "KH" would be null, but its text so .. still an error.

=Nz(DLookUp("[KH]";"Project";"[Projectnr] = " & [Projectnr]);0)

 

[spikepl]

@Uncle Gizmo

We are not looking forward to your resignation, but the UK monopoly on Colins has obviously been broken

 

[ikzouhetnietweten]

THe normal lookup works, just when dont fill in a projectnr its giving me an automatic error.
=DLookUp("KH";"Project";"Projectnr=" & [Projectnr] & "")

 

[JHB]

..., just when dont fill in a projectnr its giving me an automatic error.
..

Exactly - projectnr can be Null/Empty so why not do test as the first thing. Use the function IsNull combined with the IIF function.

 

[ikzouhetnietweten]

I did, still an error :

IIf(IsNull(DLookUp("KH";"Project";"Projectnr=" & [Projectnr] & ""));0;DLookUp("KH";"Project";"Projectnr=" & [Projectnr] & ""))

 

[JHB]

I did, still an error :
...

No you didn't - you tested if DLookUp could Be/Return Null/Empty. That was not what I wrote.

 

[ikzouhetnietweten]

You wrote , use the Iff function with isNull, so I did. As the Dlookup already works I put it in that function.. could you tell me what test code (function) I need to use first? tnx

 

[JHB]

... As the Dlookup already works I put it in that function....

Not correct - DLookUp does not work when [Projectnr] is Null/Empty.
I also wrote:
If something can be Null/Empty - then make a test for it first.
So make a test for the Projectnr first.
If it is Null/Empty return "",
else LookUp if a the Projectnr already is in the table.

=IIf(IsNull([Projectnr]);"";DLookUp("KH";"Project";"Projectnr=" & [Projectnr]))

 

[ikzouhetnietweten]

Thank you, it's working now, it's a bit like Excel Vlookup +rep4u

 

[JHB]

Thank you, it's working now, it's a bit like Excel Vlookup +rep4u

Okay - hope you learned something - that's enough to tackle.

 

[jdraw]

There is nothing wrong with cross posting --just let the unpaid volunteers who are trying and willing to help you know that you have posted elsewhere.

It's simply a copy and paste of the URL. Seems a minimal effort to get help from people.

There is never a need to make multiple posts in one forum on the same problem. Mods will collapse them into one if the issue is found.

Many of us will highlight the cross posting when found/encountered. No need to be working away on something that has been solved.

Not many cross posters ever show the solution result on the various forums involved. Most don't even thank the person solving their issue.