Unbound Text boxes

[kyleg222]

I have many Unbound Text boxes in a form for user input. There are 20 rows which the following columns:



Item Number | Quantity | Description | Unit Price | Amount


I have the input fields to unbound because we rarely order the same thing and therefore there is no need to send the inputted data back to a table. I just want to have it save a copy of the form with the inputted data being saved just in case there needs to be a modification. This form is printed and sent to vendors.

I would use labels as they are only text but you cannot go into form view to input data into labels.

In addition some of these text boxes have calculations. For Example: Amount = Quantity * Unit Price

At the bottom of the 20 columns is a total textbox that sums up all of the amount textboxes. Is there a way to make the total sum up the amount textboxes even if some of the textboxes are blank.

What I mean is in excel a blank cell is interpreted as a zero is it possible to make a blank textbox be interpreted as a zero?

Best Regards and thank you in advance for your help.

[June7]

You can have the textboxes show default value of zero. Or in the expression that sums the textboxes us Nz function.

Nz(textbox1,0) + Nz(textbox2,0)

[kyleg222]

Thank you very much June7, the Nz function did exactly what I was looking for.