INSERT statement not working for one field

[krc777]

Hello-
I have an Insert statement that has a dozen fields that update just fine. One field in the list remains blank after the module has completed. I have checked on the data type, field size etc.. and everything matches. If I change the field size to 2 it fills the field with the one digit leaving a blank in the first space. I have trim statements everywhere this field is called.
Any thoughts on something I may be missing in this?
Thanks,
k

 

[RuralGuy]

If it helps you, there is no saving by defining a field too small. Access *only* uses the size of the actual data and reserves nothing until data is stored.