By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,503 Members | 2,788 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,503 IT Pros & Developers. It's quick & easy.

Sum text boxes / from subform question

P: 45
Hello

Sorry everyone, I am back again - I have tried to find the answer and after 2 hours of not getting anywhere I have finally given in.

I have a form with several text boxes which are totaling from several subforms. These are fine when there is data in the subforms. However when there isn't any data in the form i would like it to give 0.00 as the sum, so the rest of the calculations can still work. If the subform doesnt have data the calculations I do on that sum doesn't return anything.

Or perhaps I could get the additional sum I am trying to calculate on the sum text boxes to ignore nulls?

At a complete mind block!

Many Thanks


D
Jul 22 '07 #1
Share this Question
Share on Google+
2 Replies


P: 45
Hello

Sorry everyone, I am back again - I have tried to find the answer and after 2 hours of not getting anywhere I have finally given in.

I have a form with several text boxes which are totaling from several subforms. These are fine when there is data in the subforms. However when there isn't any data in the form i would like it to give 0.00 as the sum, so the rest of the calculations can still work. If the subform doesnt have data the calculations I do on that sum doesn't return anything.

Or perhaps I could get the additional sum I am trying to calculate on the sum text boxes to ignore nulls?

At a complete mind block!

Many Thanks


D
Finally discovered how to do it! And thought I'd share lol...

In the control source of the text box:

=IIf(IsNull([Text85]),"0",([Text85]))

This will show "0" instead of " " if that makes sence??
Jul 22 '07 #2

xpun
P: 39
Finally discovered how to do it! And thought I'd share lol...

In the control source of the text box:

=IIf(IsNull([Text85]),"0",([Text85]))

This will show "0" instead of " " if that makes sence??

Instead of going through all of that trouble why not just set the format of those textboxes to currency
Jul 25 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.