reading formfields dropdown value 1

[spruceni]

Hi

I am using access VBA to open a word document and read the contents of various formfields. I am stuck on the dropdown fields. If I use

strName = .FormFields("ddReferred").Dropdown.Value

I get the index of the dropdown field. How do I get the actual text in the dropdown field? This would save me having to do a lookup for the text, the index referrs to.

Regards

Alan

 

[Remou]

How about:

[tt] .FormFields("ddReferred").Result[/tt]

http://lessthandot.com

 

[spruceni]

Thanks for this. I thought it would be different from a formfield text box and never tried it.

Alan