Default value of "" in a currency field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have about 20 currency fields on a form. I would like the default value to
be blank instead of $0. I am enter "" in the default value of the table and
the field on the form but it is working. Any suggestions?
 
That isnt working either. Do I need to enter it a certain way? I tried Null
=IsNull - neither is working
 
smboyd said:
That isnt working either. Do I need to enter it a certain way? I tried Null
=IsNull - neither is working
Click to expand...

A default value of Null is accomplished by having no entry at all in the
default value property.
 
And to add to Rick's note.... if you leave the control's Default Value blank
in the form's design, be sure that the field's Default Value in the table is
also blank.

I set Null as a default value by just typing Null in the Default Value
property box for the control in the design view of the form.
 
Back
Top