Sum in unbound textbox

[adeebarsad]

Hi!
I have a form called Form1 with many *bound textboxes I simply need to sum. I've changed the format to general number both in table and in field properties but the result is still in string. I've put this in the source code: =([Text0]+[Text1]+[Text2]+[Text3]+[Text4]+[Text5]+[Text6]+[Text7]+[Text8]+[Text9])

The result should've been 3 instead of 0100001001. Anyone knows what's the problem here? I've tried subtracting and others but it works okay.

[CJ_London]

you said the controls are unbound, but then say you have changed the format in the table and field properties. It can only be one or the other. The other point is that formatting does not change the underlying datatype - which needs to be numeric.

[adeebarsad]

Its bound, my mistake

[davegri]

What's the recordsource for form1? If it's a table, what's the table structure, a query, what's the query string.

I've tried subtracting and others but it works okay.

Can you expand on this?

[adeebarsad]

It's a table

[davegri]

You'll need to use the SUM function in a totals query.
SUM works vertically in a column of records.
How did you decide to include only 10 rows in the table?
What is the data property for the Na2CO3 fields?
What is the purpose of the comboboxes? Do they have anything to do with what's in the Na2CO3 textboxes next to them?

[adeebarsad]

The SUM only works if I want to sum all of the Na2CO3 field. I only want to choose some of it. The combo box is the list containing all the test ID I want to choose from Table1 and the Na2CO3 textbox next to it is the result of choosing from the test ID combo box.

[davegri]

I'm unable to duplicate your problem with a test setup. You'll need to upload your DB so that we can see it.

[adeebarsad]

Here you go

[davegri]

=Val([Text0])+Val([Text1])+Val([Text2])+Val([Text3])+Val([Text4])+Val([Text5])+Val([Text6])+Val([Text7])+Val([Text8])+Val([Text9])