I
IvoryT
A 3rd party supplies me with Access tables where all the
text fields are "Fixed Size" (that's what shows up in
Documenter as the "Attributes:" property of each field.
When I try to use SQL to enter a zero-length string in
these fields, Access instead stores all blanks, where the
number of blanks = the size of the field.
I know that if you create a table from the Design View,
text fields by default have Attributes= "Variable Size".
But I can't find a way to convert fixed to variable. Does
anyone know how to do this? Changing the value of
the "Allow Zero Length" property has no effect.
thanks
text fields are "Fixed Size" (that's what shows up in
Documenter as the "Attributes:" property of each field.
When I try to use SQL to enter a zero-length string in
these fields, Access instead stores all blanks, where the
number of blanks = the size of the field.
I know that if you create a table from the Design View,
text fields by default have Attributes= "Variable Size".
But I can't find a way to convert fixed to variable. Does
anyone know how to do this? Changing the value of
the "Allow Zero Length" property has no effect.
thanks