Dear All,
I have a table in Access 2013 with a field that has the Required property set to No and the Allow Zero Length Strings property to Yes.
I am trying to insert an empty ('') value into this field - I tried putting in a white-space, typing some text and then deleting it to no availability. When I run the query
this entry will be reported.
Is there a way of saying I want an empty string for the value rather than null (if you set Required to yes, null is out of the question anyway so there is no problem with this setting)?
Regards,
George
I have a table in Access 2013 with a field that has the Required property set to No and the Allow Zero Length Strings property to Yes.
I am trying to insert an empty ('') value into this field - I tried putting in a white-space, typing some text and then deleting it to no availability. When I run the query
Code:
select * from table_name where field_name is null;
this entry will be reported.
Is there a way of saying I want an empty string for the value rather than null (if you set Required to yes, null is out of the question anyway so there is no problem with this setting)?
Regards,
George