Fields collection.

[AnanthaP]

I need to now all the values of the filed object of the fields collection. Eg. What is the value for the REMARK column?

Eg: Name, Value, Type, Precision, NumericScale, DefinedSize, ActualSize are all OK. What about the remark column? How do I access it?

End

 

[TonyJollans]

Hi AnanthaP,

By Remarks, I assume you mean Description. The Description is held in the Description Property, which only exists if there is a description on the Field.

You can look at all the properties of a field by looping through its Properties collection, but be aware that some of them, in some circumstances, may not have 'valid' values.

[blue]Dim objP as DAO.Property
Dim strS as String

For Each objP in DbEngine(0)(0).TableDefs![i]YourTable[/i].Fields![i]YourField[/i].Properties
    strS = objP.Name & ":  "
    On Error Resume Next
    strS = strS & objP.Value
    On Error Goto 0
    Debug.Print strS
Next[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.