Zeros

[NAA]

I have created a form & report from a table to enter a Purchase Order we have
4 fields
Example:
Qty U/M Description Unit Price Total Price
1 ea Rulers 15.00 15.00
(field types)
Qty Number
U/M Text
Description Text
Unit Price Currency
Total Price Currency
And I want to get rid of these zeros.
Example:
Qty U/M Description Unit Price Total Price
1 ea Rulers 15.00 15.00
0 $0.00 $0.00

 

[Stockwell43]

Hi NAA,

These are the defaults for these data types. To get rid of the Zeros change
all the data types to Text. There may be a way to change it through VBA but I
don't know of any.

Hope this helps!!

 

[John W. Vinson]

I have created a form & report from a table to enter a Purchase Order we have
4 fields
Example:
Qty U/M Description Unit Price Total Price
1 ea Rulers 15.00 15.00
(field types)
Qty Number
U/M Text
Description Text
Unit Price Currency
Total Price Currency
And I want to get rid of these zeros.
Example:
Qty U/M Description Unit Price Total Price
1 ea Rulers 15.00 15.00
0 $0.00 $0.00

Open the Table in design view; and select the three fields Qty, Unit Price and
Total Price one at a time. On the lower left of the screen blank out the 0 in
the "Default Value" property.