Currency field default

[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!

 

[John W. Vinson]

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!

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]