Drop Down Menu Follow

0
Avatar
Legacy Poster

Is it possible to create a drop down menu where the Display text & the Sub-string Value are different, using VB-Script?

For example..

[code]Display Text Sub-string Value
1 Tom
2 Dick
3 Harry[/code]

Thanks for any help you can provide.

5 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

This can be done in the properties of the drop down list under the "List Items" tab. Simple untick the, "Use same values for display text and sub-strings" checkbox and then in enter the differing values as wanted. See the attached screen shot.
0
Avatar
Legacy Poster
Comment actions Permalink

[quote name='Ian C - Seagull Support' timestamp='1316165133' post='623']
This can be done in the properties of the drop down list under the "List Items" tab. Simple untick the, "Use same values for display text and sub-strings" checkbox and then in enter the differing values as wanted. See the attached screen shot.
[/quote]

Sorry, i should have been a bit clearer. I am pulling the data from a spreadsheet, so need to be able to do it via vb script. Is it possible to have different Display Text & Sub-string Values via vb script?
0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

No, I don't think this is supported at present.
0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

I suppose that if the VB script contained display items, your VB script could then go on to use a Select...Case statement to substitute the display value with the value you will assign the sub-string at print time. This is applicable if the list isn't too long.
0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

I've got some new information on this one. You can use vbTab to separate name-value pairs:

Value = "List Item 1" + vbTab + “Value1” + vbCr + "List Item 2"+ vbTab + “Value2”

See the newly attached screenshot.

Please sign in to leave a comment.