Link to home
Start Free TrialLog in
Avatar of PARADELA
PARADELA

asked on

Cannot change the value of a field to zero lenght using Visual Basic 6.0 and a Microsoft Access 2000 Database

I am using Visual Basic 6.0 and a Microsoft Access 2000 Database.  I am using a ADO data control.  Once I write to a field I cannot delete the value in the field. For instance if I enter a value in the field  phone number and which to delete it because the patient has no phone number or has had it disconnected, I get the following error message: [Microsoft][ODBC Microsoft Access Driver] Field'demograpTbl.PhoneNumber' cannot be zero-length string.  The field property is set so that PhoneNumber is not a require field.
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

required property of the field is different from allow zero length
allow zero length should be set to Yes
using ADO
use Column.Properties("Set OLEDB:Allow Zero Length")
ASKER CERTIFIED SOLUTION
Avatar of Arthur_Wood
Arthur_Wood
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
oh well, what can I say?

AW