Fill Formfields based on DropDown

[Shred Dude]

You wouldn't know of a way to autosize the content control's drop down list's width based on its contents would you?

It seems by default its a function of the currently selected item's width.

Only thing I've figured out so far isn't pretty. I can append a few spaces on the end of my shorter entries, so that all entries end up being the same length. but then I have to but a trim statement in the code when trying to use one of those selected range.texts. It happens to work with the data I presently have, but I can see some shortcomings with the approach if I had different data.

[Shred Dude]

EDIT:

Found a better way...

It seems the width can be manipulated by changing the width an entry, so I modified the first entry to act as a placeholder.

[VBA]activedocument.SelectContentControlsByTag("panel").Item(1).DropdownListEntr ies.Item(1).Text = "Pick a Panel >"[/VBA]

[gmaxey]

Keith,

My middle name. Easy to remember. Pleased I could help. I am sure there is plenty that I could learn from you!!