How to get a "" value in stead of "0"

[marcvanderpeet12]

Dear all,

I have created a form in which I have to enter some details (including a number). Thing is that access now automatically fills in a "0" if I do not filll in anything. I do not want this however cause the value needs to be blank (=""). See attachment



Anybody a clue on how I can fix this?

Thanks!

[alansidman]

In the properties for the table, have you set up a default value of zero for the particular field?

[June7]

Yes, sounds like 0 is set as default in table.

Remove this and the field will be Null if no value entered, not "" which is an empty string. Null and empty string are not the same things. A number field cannot have a string, empty or not.

[marcvanderpeet12]

It does not work. If I fill in nothing at default value, still a "0" pops up in my form....

Yes, sounds like 0 is set as default in table.

Remove this and the field will be Null if no value entered, not "" which is an empty string. Null and empty string are not the same things. A number field cannot have a string, empty or not.

[alansidman]

You may want to upload a sample of your database sanitized for confidential material (put in dummy data). Then it can be analyzed otherwise, it is as if we are tossing darts blindfolded.

In the quick reply window, click on go advanced. Run a compact and repair before uploading.

[ipisors]

This is probably because the field is currency. Why would you want the default to be a zero length string (if it's even possible) if the field type needs to be currency? Rarely do people trade goods or services for "" It's either 0 or it's a number.

That's the default Access behavior ... and with good reason.

I think you may need to re-think the field type, and the why behind your wanting a ZLS instead of a zero.

But there may be other issues too. Are you creating a user interface where the user interacts directly with a table? If so you shouldn't be ... Access is not a spreadsheet.

[June7]

Are you saying the field does not have DefaultValue and new records still show 0? Then something else is going on. If it were defined as Currency there would be currency symbol.

Existing records have already been populated and removing the DefaultValue property does not impact those existing records. You will have to edit them. Can run an UPDATE query to change 0 to Null.