Assigning a default value for nulls in Access

neale · Joined: 21 Dec 2004 Posts: 27

Why does assigning of nulls in some particular fields as default are not working for me? The only way to do that is to mark all fields as “required” all of them and I must set the allow nulls to false setting, even those which are supposed not to be. This is required for me just to prevent doubled, identical record import twice, and nothing else. How do I do that? I don’t want to see 0 (manually added) for every null as a part of this index?

wiatt · Joined: 26 Oct 2003 Posts: 111

Hello. I think that you can set the default value for the particular field from the design view mode, there you will be able to allow zero lengths also, but you already tried that? Anyway, this might not work for the date fields.. Then you should try with Empty as input for the particular field, and that is supposed to apply to all sort of value fields, I am sure.

H-Desk.com - PC Security matters - Protect your PC privacy

Assigning a default value for nulls in Access

LIFEFORM SOCIAL COMMUNITY NETWORK