Access Form Correction

[ElPerson]

Hi
**SEE the ATTACHED SCREENSHOT
I have Access Form and hope you help me with the following
1>Want the Keep the Fields empty unless i type in them, now every time i start writing the customer name it fill the rest with "0"??
2>want Access to auto calculate and fill the "Amount to be Paid" based on my entry of the field "Number of Boxes" i mean the "Amount to be paid should be the result of number of boxes *55.5
3>want the access add the now date at time of data entry

Thank you

 

[jdraw]

Tell us about your table(s). It would help readers understand your database if you could tell us more about the "business"/application involved.

Welcome to the forum.

 

[ElPerson]

Hi

My table is for a small business that sell a cheese boxes and the table contain the same column in the form
Customer
Number of Boxes
Paid or NOT
Amount to paid
Date

Thank you

 

[June7]

Cross post http://www.accessforums.net/showthread.php?t=77009

 

[jdraw]

This is the typical set up for Customers who Order Products/Items.

 

[gemma-the-husky]

0 is the default value for a bound numeric value. If you don't want to see a zero, remove the default from the field definition in the table.