A text field is initially 40 characters long and one record has an entry in this field in MS-Access database.
A text field is initially 40 characters long and one record has an entry in this field in MS-Access database. The field value contains 28 characters, including spaces. Now, you have reduced the length of the field to 20 characters. What will happen to the field value?
4 views
1 Answers
Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.
4 views
Answered