default value does not work at access 2005

[newaccess]

I have a data enter form. at some fields, I put 0 as a default value under data tab for that filed properrty. However, it does not work. the linkable oracle still shoe nulll value.
What kind of issue is in here?

Thanks
new access

[alansidman]

Please read
http://www.excelguru.ca/content.php?184
Crossposted: http://www.access-programmers.co.uk/...d.php?t=240375

[newaccess]

Thanks for your information

[June7]

You are setting the DefaultValue property of textbox? Maybe you need to set the default value in the table. http://www.techrepublic.com/article/...olumns/5239302

Do you have other bound textboxes with DefaultValue set that do work properly.

[newaccess]

Thanks for your information. Yes. I also set default in DB side. But this way is only work when insert SQL statement to omit column.
As form side. I think the issue resulted from auto generated form by access form ward with table. It should created a blank form and then assign each text box to map into table. But this way need to more vba codes .

I am new access person and try to use access form wizard. But I get this pain now.

new access

[June7]

I never use the design wizards because they do things I don't like.