[RESOLVED]Strange problem when saving records

[sacramento]

hi to all:

This code i had use for create a field in DB Access 2003:

 SQL = "ALTER TABLE plano_contas ADD declperiodica06A char(40) WITH COMPRESSION NULL)"
        Dim command1 As New OleDb.OleDbCommand(SQL, con1)
        con1.Open()
        command1.ExecuteNonQuery()
        con1.Close()

like you see the code create a Text field with 40 lenght...
Well the problem is:
When i save a new record the record it's save in this mode:
"100..................................." - the points means spaces
and should be:
"100"

After try a lot of things i'm without more solutions in find why this happen!
Someone can give me some help here?

Thanks