I need help with changing a text field required property in an access 2000 format database file from yes to no. it has to be done through code. I use ADO. It currently is set to no and its causing problems when the user doesnt enter text into this field and I dont want to force them to because it really isnt needed in all cases.