Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you show a zero on a form from a dlookup?

Status
Not open for further replies.

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
 
Felix,

Try something like this:
Code:
=IIf(IsNull(Your DLookup statement), 0, Your DLookup statement))
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top