Currency field default

  • Thread starter Thread starter Tara
  • Start date Start date
T

Tara

I have an unbound currency field that defaults to $0.00. I need it to
default to Null. The issue is that there are times when I'm interested in
whether or not there is a value, not necessarily what the value is, so having
it default to $0.00 creates a problem.

Thanks in advance!
 
I have an unbound currency field that defaults to $0.00. I need it to
default to Null. The issue is that there are times when I'm interested in
whether or not there is a value, not necessarily what the value is, so having
it default to $0.00 creates a problem.

Thanks in advance!
Click to expand...

Open the table in design view (in the backend database, if it's a split
application). Select this field and look at its properties (in the lower left
of the screen). Either blank out the Default Value property (removing the 0
that Access "oh so helpfully" provides), or replace it with NULL.

John W. Vinson [MVP]
 
Back
Top