Caption Text 2

[JohnTulley]

Could anyone show / explain how I can read the Caption text of the Field properties of a table in VBA, preferably using a recordset.
Any help would be greatfully received.

 

[JeffTullin]

msgbox myRs.Fields("Name&quot.value

or
msgbox myRs.Fields(1)value

 

[TonyJollans]

Hi JohnTulley,

If a Table Field has a Caption, then the Field in a Recordset based on it should inherit the Caption. To get it I think you need to index into the Properties Collection ..

RecordsetName

.Fields("

FieldName

").Properties("Caption")

But note that if the Field doesn't have a Caption, the Property won't exist so you will get an error if you try to reference it.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.