used to know how to set 0 to show nothing Null or blank

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

Guest

I used to know how to do this a few years ago. Have a field in a table set
as a number.

On the form it automatically sets it to 0. How can I have it blank or null
until I decide if the number should be set to 0. If I decide not to make an
number entrie in the field, just leave it blank.
 
Sounds as though you've got a Default Value set, either for the field in the
table, or the control on the form. Just leave the DefaultValue property
empty (and make sure that the table field isn't set as Required)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

more or less than 0 or blank 3
Convert zero-length string or blank cell to null 3
NZ Function and Null VS 0 values 2
null validation rule 1
#error - Blank 3
Dsum but £0.00 if null 3
How to enter a Wildcard or Is Null into a query paramater ? 7
DCount Nulls 4

Back
Top