default value

[bakerboy_1111]

I have created a query, and one of the columns in this query is called number. I've set this column to a combo box, and the choices in the combo box are called from a number table that has the numbers, 1,2,3,4,5,6, etc. If i create a new entry in my query, then the number value defaults to zero (which isn't in my number table). More often than not, I will need to leave this number column in the query blank. I cannot leave it as zero because it is not an entry in the table. I have to actually go to the column each new entry and delete the number 0.

Is there any way I can set up a default value of null, instead of deleting the zero every time a make an entry?

Thanks for any replies.

 

[Pat Hartman]

Change the default in the table. Right now it is set to default to zero. Simply delete the 0 from the default property.

 

[bakerboy_1111]

Thanks for your response.

I tried doing what you suggested , but the zero keeps coming up in the query, but not the table. I also tried setting the default value to "Null" but that got the same result.

Is there anything I can toggle in the actual query?

 

[Pat Hartman]

Are you using the IIf() or Nz() functions to replace null values with 0?

 

[bakerboy_1111]

Sorry Pat,

The problem was fixed the way you suggested, it was just that I had two tables that both used the number, and I changed the wrong one.

Thanks for your help.