Dear All,
This might sound as an odd question, but I am interested into whether it is possible or not. Let's say I have a table with a text field and Required is set to Yes and Allow Zero Length Strings to No.
I want to input a value for this field which is "" (two double quotes literally). If you try to do that, Access thinks that you are trying to enter a zero-length string and the entry is blocked so I guess I have to escape them - coming from a programming background I tried \ but this resulted in the value \"\" going in and [] as I read on a webpage but this resulted in ["]["] in going in.
So the question is: if I want a value of "" to be the value and not the empty string how do I tell Access this is the case?
Regards,
George
This might sound as an odd question, but I am interested into whether it is possible or not. Let's say I have a table with a text field and Required is set to Yes and Allow Zero Length Strings to No.
I want to input a value for this field which is "" (two double quotes literally). If you try to do that, Access thinks that you are trying to enter a zero-length string and the entry is blocked so I guess I have to escape them - coming from a programming background I tried \ but this resulted in the value \"\" going in and [] as I read on a webpage but this resulted in ["]["] in going in.
So the question is: if I want a value of "" to be the value and not the empty string how do I tell Access this is the case?
Regards,
George