fixed size versus variable length fields

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
 
G

Guest

Did you try checking the format property of the field you are trying to update/insert?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Does Access store data in fixed lenght or variable length format 2
Allow Zero Length 6
Are rows stored in fixed or variable length records. 3
How to create a memo field with a fixed length of 2000 characters 13
Best Text Field Defaults: Null or Zero Length String 4
controlling fields on a form 3
Text Field Size - Access 2007 2
blank fields issue 2

Top