MS Access "Required" field setting ignored

  • Thread starter Thread starter Matthew Marsh
  • Start date Start date
M

Matthew Marsh

I have an Access 2000 table. One of the fields has the "Required" setting
set to "Yes".

This setting is not being picked up by VS.Net and the fields value is
allowed to remain empty when entering new records.

When I look at the Dataset Properties window (in VS.Net 2003), the
"AllowDBNull" is set to True.

Can someone please tell me why the field setting is being ignored and how to
correct this ?

Many thanks
Matthew
 
Thanks for this. The field in question is for a Company name, so a default
value would not work.

Any other ideas ?

Thanks
Matthew
 
¤ I have an Access 2000 table. One of the fields has the "Required" setting
¤ set to "Yes".
¤
¤ This setting is not being picked up by VS.Net and the fields value is
¤ allowed to remain empty when entering new records.
¤
¤ When I look at the Dataset Properties window (in VS.Net 2003), the
¤ "AllowDBNull" is set to True.
¤
¤ Can someone please tell me why the field setting is being ignored and how to
¤ correct this ?

I believe the property you are referring to maps to Allow Zero Length. Try setting this to No (in
Access) and see if there is any change.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
I already tried this but no joy.

Also, I tried creating the same table using MSDE and it works fine.

It appears that the MS Access setting is being completely ignored, which is
rather annoying.

Thanks

Matthew

 
Back
Top