QueryDef Field Properties -- CAPTION?

[DonS]

I used to extract the CAPTIONS property from the fields in QueryDefs. I was
hitting Access 97.

I was using code like...

qdf.Fields(intFieldCounter - 1).Properties("Caption")

When I upgraded to Access 2000, I could no longer find that property. Even
when I cycle thru the field properties with code and display each one, I do
not see the CAPTION property.

Did Access 2000 do away with that property? If so, why can we still fill
one out on the QBE interface form?

Please help.

 

[Dale_Fye via AccessMonster.com]

I don't know about 2000, it's been quite a while since I've used it, but you
can do it in the 2007.

Only thing is that you need to ensure you have some error handling, because
this property doesn't exist until an entry has been made in the property, and
will return an runtime error (3270 - Property not found) if you refer to it
before a caption has been applied.

Dale