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

[June7]

1. Is DefaultValue property set to 0 for field in table? Remove the 0.

2. Use an expression in textbox ControlSource property that references the quantity field name, example: =[Quantity]*55.5. Saving this calculated value to table will require code (macro or VBA). There is no need to save in table, calculate when needed.

3. Is this a Date/Time field in table? Set DefaultValue property to: Now()

This is all very basic Access functionality. Have you studied an introductory tutorial book?

[ElPerson]

1>The default value was empty and the 0 always showing the field, so i set the default value to "", the 0 disappeared BUT once i start writing in any of the fields in the form it shows the 0 again in the rest of the fields.
2> i hope to save the result to the table, would you please give me a VBA Please
3> the date is Done successfully

[June7]

1. If field is number type, using "" should error because that is an empty string and number fields cannot hold empty string. Don't set DefaultValue in table. Make sure the textbox DefaultValue property has nothing in it as well.

2. Me!Amount = Me.tbxAmount - use your real field and textbox names. The trick is figuring out what event(s) to put code into, perhaps the form BeforeUpdate event. This is a common topic and many examples can be found. Again, advise NOT to do this for such a simple calc.