By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Fields padded by spaces

P: n/a
I am having a problem where fields are being filled by spaces when data
is put in.

I.e. in a text field length 50, whatever is stored in there is padded
by spaces and the field length is always 50.

Any ideas why this is happening or how to stop it?

Thanks

Jan 3 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Sounds like you have a fixed-width field here, instead of the variable width
that is the standard in Access.

You can't create this kind of field in the interface. It usually happens via
DDL because someone used a CREATE TABLE with CHAR(50) instead of TEXT(50).

Delete the field, and recreate it via the interface or TEXT(50).

For a reference that compares the DLL names to the names in the interface,
see:
Field type reference - names and values for DDL, DAO, and ADOX
at:
http://allenbrowne.com/ser-49.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"andrewbda" <an*******@gmail.comwrote in message
news:11**********************@a3g2000cwd.googlegro ups.com...
>I am having a problem where fields are being filled by spaces when data
is put in.

I.e. in a text field length 50, whatever is stored in there is padded
by spaces and the field length is always 50.

Any ideas why this is happening or how to stop it?

Thanks
Jan 3 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.