Get field attributes from code

[SpiderByte]

I am trying to retrieve the attributes of a field eg data type, caption, length etc using vba code. Also can the attributes be changed, in particular the caption as well as the attributes. I would think using ALTER Table would be the go?