Apparently there is a design issue which I don't understand. I have a table with an Account column (account number). It's of
type TEXT and length 50.
For some reason Jet has it as a fixed-length column. How do I undo that? That is to say, even if I insert a 10-digit account
number, Jet is storing a string of 50 characters (40 spaces).
I'm accessing the DB from VB.Net (actually C#.Net) but have the same problem even when I try it from Access VBA. Due to the
fixed-width, even if I run this query,
UPDATE Posted SET Account = Trim(Account)
Jet ignores it - I still get a 50 char string when I run a select query from the table.
SELECT Account FROM Posted
The only way to get a 10-char string is this:
SELECT Trim(Account) FROM Posted
How did I get a fixed-width column?