Returning a zero value in a subform text box if a query value it isbound to is null

[RMTechie]

Is there a way to return a zero value in a subform text box if a query
value it is bound to is null? When the query value is null, the text
box doesn't show up, and I'd like to have it there all the time.

 

[Ryan]

Yes there is. Check this link to the NZ function. It should do what you are
looking for.

 

[Ryan]

Ooops, forgot the link, haha.
http://office.microsoft.com/en-us/access/HA012288901033.aspx