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

R

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.
 
R

Ryan

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display zero value in blank fields of Cross Tab query 0
Word OLE to check spelling in text box 1
Clearing combo boxes and a text box 2
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Link a text box based on drop down box with four options MS Word 365 0
Calculate the median value before a specified list 0
if a # then sum, if text leave null 2
Drop down list control value in vba 2

Top