Why is it a good idea to set the Allow Zero Length property to No for fields with the Text or Memo data types?
What will be an ideal response?
Student answers will vary.
Access treats a null field value and a zero length field value differently. When a text or memo field has the Allow Zero Length property set to Yes, it is not possible to determine if the field value is null or has a zero length value because both look the same. To have records with a zero field length appear in a query recordset, it is necessary to set the Allow Zero Length property for Text and Memo data type fields to No.
You might also like to view...
Suppose ArrayList x contains two strings [Beijing, Singapore]. Which of the following methods will cause the list to become [Beijing, Chicago, Singapore]?
a. x.add("Chicago") b. x.add(0, "Chicago") c. x.add(1, "Chicago") d. x.add(2, "Chicago")
When creating the AbstractCollection class, which methods must you modify to provide default behavior?
A. __len__ and count B. __str__ and __eq__ C. isEmpty and add D. __init__ and __len__
Conditions in the computing environment changed dramatically in the late 1960s due to the development of ________ and integrated circuits.
A. parallel CPUs B. dedicated GPUs C. transistors D. silicon chips
In order to ensure drive health, what command should you use to search for a repair file system error?
A. defrag B. chkdsk C. Analyze D. Optimize