#Type! error

[plavookins]

I created text box and wanted to sum two text boxes values in form (=[Količina bruto:]+[Količina bruto1:]). I receive error #type!... what is the problem...?

 

[boblarson]

First off, why do you have a colon in the name of the text box? That right there would be a red flag for me. You do not use special characters like that in the names of objects. It will only lead to pain and suffering.

Second, are you sure you are referring to text boxes and not labels? You can't sum labels.

Third, so if they are text boxes and you change the names to get rid of the colon ) then you should also use the NZ function in case either is null or else it will not give you a value:

=[TextBox1NameHere] + [TextBox2NameHere]

should be

=Nz([TextBox1NameHere], 0) + Nz([TextBox2NameHere],0)

 

[plavookins]

first, thank you for answering. It is a text box, not a label. I know all the field should be filled and understand nz. I attached my database so you can see..... Form "otpremnica" text box text142 ....