simple form calculation won't calculate

M

Mark M Simonian

I am using a simple addition calculation in Access 2007 and it will not show
the result. Simple form based on a single table field 1 and field 2 with a
following unbound field with the control =[filed 1] + [field 2] after
tabbing through field 1 (all formatted as currency) then field 2 and tab
into the following unbound field and no value shows until I press F5 and
return to the record with the unbound field and then the tabulation
calculation appears. I am clueless why this shouldn't calculate the result
as I enter into the unbound field. Any ideas appreciated

--
***************************
Mark M Simonian, MD
681 Medical center Dr West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com
(e-mail address removed)
 
K

Klatuu

A couple of minor points. Regardless of Microsoft's misinformation, forms do
not have fields, they have controls. Tables and Querys have fields. Second,
it is not a good idea to use spaces in names.
Now, It is most likely the calculation is taking place and presenting the
result, but the result is Null so therefore is not visible. Null + anything
= Null.
I would suggest you enclose each value in the Nz function. The Nz function
will convert a Null to the specified return argument, but return non null
values.
Try:
=Nz([filed 1],0) + Nz([field 2],0)
 
M

Mark S

Dear Klatuu, Thanks so much for the suggestion and apologize for not using
the proper naming terminology. In order to see the total I still must press
F5 to refresh and click into a combobox to reselect the appropriate record.
Changing the formula did not help show the results immediately as I would
hope. It is not a lot of trouble but thought it should show the value
immediately upon entering the unbound control. Am I wrong? Mark Simonian


Klatuu said:
A couple of minor points. Regardless of Microsoft's misinformation, forms
do
not have fields, they have controls. Tables and Querys have fields.
Second,
it is not a good idea to use spaces in names.
Now, It is most likely the calculation is taking place and presenting the
result, but the result is Null so therefore is not visible. Null +
anything
= Null.
I would suggest you enclose each value in the Nz function. The Nz
function
will convert a Null to the specified return argument, but return non null
values.
Try:
=Nz([filed 1],0) + Nz([field 2],0)
--
Dave Hargis, Microsoft Access MVP


Mark M Simonian said:
I am using a simple addition calculation in Access 2007 and it will not
show
the result. Simple form based on a single table field 1 and field 2 with
a
following unbound field with the control =[filed 1] + [field 2] after
tabbing through field 1 (all formatted as currency) then field 2 and tab
into the following unbound field and no value shows until I press F5 and
return to the record with the unbound field and then the tabulation
calculation appears. I am clueless why this shouldn't calculate the
result
as I enter into the unbound field. Any ideas appreciated

--
***************************
Mark M Simonian, MD
681 Medical center Dr West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com
(e-mail address removed)
 
K

Klatuu

Is the calculation in the unbound control's Control Source Property?
If not, that might account for your problem.
No apology necessary, only trying to help. I guess I am terminologically
obsessive. As you know, in your profession incorrect terminology can have
undesired consequences :)

BTW, I would not recommend posting that much personal information on this
site. It is trolled frequently and you may get spam from it.
--
Dave Hargis, Microsoft Access MVP


Mark S said:
Dear Klatuu, Thanks so much for the suggestion and apologize for not using
the proper naming terminology. In order to see the total I still must press
F5 to refresh and click into a combobox to reselect the appropriate record.
Changing the formula did not help show the results immediately as I would
hope. It is not a lot of trouble but thought it should show the value
immediately upon entering the unbound control. Am I wrong? Mark Simonian


Klatuu said:
A couple of minor points. Regardless of Microsoft's misinformation, forms
do
not have fields, they have controls. Tables and Querys have fields.
Second,
it is not a good idea to use spaces in names.
Now, It is most likely the calculation is taking place and presenting the
result, but the result is Null so therefore is not visible. Null +
anything
= Null.
I would suggest you enclose each value in the Nz function. The Nz
function
will convert a Null to the specified return argument, but return non null
values.
Try:
=Nz([filed 1],0) + Nz([field 2],0)
--
Dave Hargis, Microsoft Access MVP


Mark M Simonian said:
I am using a simple addition calculation in Access 2007 and it will not
show
the result. Simple form based on a single table field 1 and field 2 with
a
following unbound field with the control =[filed 1] + [field 2] after
tabbing through field 1 (all formatted as currency) then field 2 and tab
into the following unbound field and no value shows until I press F5 and
return to the record with the unbound field and then the tabulation
calculation appears. I am clueless why this shouldn't calculate the
result
as I enter into the unbound field. Any ideas appreciated

--
***************************
Mark M Simonian, MD
681 Medical center Dr West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com
(e-mail address removed)
 
K

Klatuu

OMG, That could happen.
Mark, If you get a post from someone currently going as Steve, ignore it.
It will probably say PC Datasheet in the signature. He is a known vulture
who offers to help, but he is trolling for business. His honesty and
competenece are questionable.
 
M

Mark S

Yes, this was an unbound control. It makes no sense why this doesn't refresh
and calculate but I solved it because I also have a subform on the same tab
and decided to add a column in the datasheet on that subform that does the
same calculation and it works fine. I am just very curious why it won't
autocalculate and requre a forced refresh and return. The results count and
I fixed it. I appreciate the advice.

I appreciate the advice on keeping my information more secure too and the
Norton screening is working somewhat.

Mark Simonian


Klatuu said:
Is the calculation in the unbound control's Control Source Property?
If not, that might account for your problem.
No apology necessary, only trying to help. I guess I am terminologically
obsessive. As you know, in your profession incorrect terminology can have
undesired consequences :)

BTW, I would not recommend posting that much personal information on this
site. It is trolled frequently and you may get spam from it.
--
Dave Hargis, Microsoft Access MVP


Mark S said:
Dear Klatuu, Thanks so much for the suggestion and apologize for not
using
the proper naming terminology. In order to see the total I still must
press
F5 to refresh and click into a combobox to reselect the appropriate
record.
Changing the formula did not help show the results immediately as I would
hope. It is not a lot of trouble but thought it should show the value
immediately upon entering the unbound control. Am I wrong? Mark Simonian


Klatuu said:
A couple of minor points. Regardless of Microsoft's misinformation,
forms
do
not have fields, they have controls. Tables and Querys have fields.
Second,
it is not a good idea to use spaces in names.
Now, It is most likely the calculation is taking place and presenting
the
result, but the result is Null so therefore is not visible. Null +
anything
= Null.
I would suggest you enclose each value in the Nz function. The Nz
function
will convert a Null to the specified return argument, but return non
null
values.
Try:
=Nz([filed 1],0) + Nz([field 2],0)
--
Dave Hargis, Microsoft Access MVP


:

I am using a simple addition calculation in Access 2007 and it will
not
show
the result. Simple form based on a single table field 1 and field 2
with
a
following unbound field with the control =[filed 1] + [field 2] after
tabbing through field 1 (all formatted as currency) then field 2 and
tab
into the following unbound field and no value shows until I press F5
and
return to the record with the unbound field and then the tabulation
calculation appears. I am clueless why this shouldn't calculate the
result
as I enter into the unbound field. Any ideas appreciated

--
***************************
Mark M Simonian, MD
681 Medical center Dr West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com
(e-mail address removed)
 

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

Top