Oct 24, 2002 #1 ffleitas Technical User Mar 15, 2001 85 US Hi programmers, How do you get a field on a form using a dlookup that has no value yet to display a zero 0 for the time being? Thanks, Felix
Hi programmers, How do you get a field on a form using a dlookup that has no value yet to display a zero 0 for the time being? Thanks, Felix
Oct 24, 2002 #2 CosmoKramer Programmer May 29, 2001 1,730 US Felix, Try something like this: Code: =IIf(IsNull(Your DLookup statement), 0, Your DLookup statement)) Upvote 0 Downvote
Felix, Try something like this: Code: =IIf(IsNull(Your DLookup statement), 0, Your DLookup statement))