How can I get Atributes from the field of the table via VBA

[Guest]

I'm using ms access 2003.
In adp, go to tables, open any table in design view, select one colune and
go to coloumn properties, CAPTION is between the property inputmask and
indexed.

Could you see?

Regards

 

[Sylvain Lafontaine]

Oh, this one was well hidden: I had to use the scrolling bar to see it.

This is stored as an extended property with the name MS_Caption. See the
following on how to retrieve these extended properties:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro02/html/sql02a10.asp

 

[Robert Morley]

D'oh! You're right, I forgot to try scrolling down. <blush>


Rob

 

[Guest]

I apreciate your knowledge, so I was surprised when you told me, Caption
doesn't exist in sql server. I checked it again, lol.

Thanks for the site, I will check if I can get the caption value

JP

 

[Sylvain Lafontaine]

The fact that about everyone here didn't know or have forgotten about this
property is a testimony to its usefulness.

 

[aaron.kempf]

CAPTION is in ADP kids

I see Caption in an MDB file, but not in any ADP's. What version of Access
are you using? Maybe it's in one version, but not the other.


Rob

 

[aaron.kempf]

Sylvain;

how is 'caption' in ADP any less useful than in MDB?

lose the training wheels, bitch