Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
I know that you can only have a drop down box be so long (NOT number of items
to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
The dropdown form field is limited to 50 characters per entry, and 25
entries. The solution for wider items is the same as the solution for more items: create a userform containing a list box. Such a list box can contain a practically unlimited number of items, each of hundreds of characters (not that it can show them all, because it won't scroll sideways). The Microsoft KnowledgeBase article http://support.microsoft.com/kb/198561 describes how to do it, and Greg Maxey's page at http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into more detail. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Thu, 11 Mar 2010 15:09:01 -0800, BDankas wrote: I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
The dropdown form field is limited to 50 characters per entry, and 25
entries. The solution for wider items is the same as the solution for more items: create a userform containing a list box. Such a list box can contain a practically unlimited number of items, each of hundreds of characters (not that it can show them all, because it won't scroll sideways). The Microsoft KnowledgeBase article http://support.microsoft.com/kb/198561 describes how to do it, and Greg Maxey's page at http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into more detail. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Thu, 11 Mar 2010 15:09:01 -0800, BDankas wrote: I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
See also http://www.gmayor.com/SelectFile.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
See also http://www.gmayor.com/SelectFile.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
I am not familiar with programming complex macros and the directions on the
site are foreign to me (sorry). Do you have a step-by-step process?? "Graham Mayor" wrote: See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
I am not familiar with programming complex macros and the directions on the
site are foreign to me (sorry). Do you have a step-by-step process?? "Graham Mayor" wrote: See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
When I print it will it wrap the text?
"Jay Freedman" wrote: The dropdown form field is limited to 50 characters per entry, and 25 entries. The solution for wider items is the same as the solution for more items: create a userform containing a list box. Such a list box can contain a practically unlimited number of items, each of hundreds of characters (not that it can show them all, because it won't scroll sideways). The Microsoft KnowledgeBase article http://support.microsoft.com/kb/198561 describes how to do it, and Greg Maxey's page at http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into more detail. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Thu, 11 Mar 2010 15:09:01 -0800, BDankas wrote: I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
When I print it will it wrap the text?
"Jay Freedman" wrote: The dropdown form field is limited to 50 characters per entry, and 25 entries. The solution for wider items is the same as the solution for more items: create a userform containing a list box. Such a list box can contain a practically unlimited number of items, each of hundreds of characters (not that it can show them all, because it won't scroll sideways). The Microsoft KnowledgeBase article http://support.microsoft.com/kb/198561 describes how to do it, and Greg Maxey's page at http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into more detail. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Thu, 11 Mar 2010 15:09:01 -0800, BDankas wrote: I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . |
#10
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
The userform itself is never printable. The described solutions show how to
take the users's selection from the list box in the userform, and insert that text into the body of the document. Once it's in the document, it's just ordinary text, so it will wrap there. BDankas wrote: When I print it will it wrap the text? "Jay Freedman" wrote: The dropdown form field is limited to 50 characters per entry, and 25 entries. The solution for wider items is the same as the solution for more items: create a userform containing a list box. Such a list box can contain a practically unlimited number of items, each of hundreds of characters (not that it can show them all, because it won't scroll sideways). The Microsoft KnowledgeBase article http://support.microsoft.com/kb/198561 describes how to do it, and Greg Maxey's page at http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into more detail. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Thu, 11 Mar 2010 15:09:01 -0800, BDankas wrote: I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . |
#11
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
The userform itself is never printable. The described solutions show how to
take the users's selection from the list box in the userform, and insert that text into the body of the document. Once it's in the document, it's just ordinary text, so it will wrap there. BDankas wrote: When I print it will it wrap the text? "Jay Freedman" wrote: The dropdown form field is limited to 50 characters per entry, and 25 entries. The solution for wider items is the same as the solution for more items: create a userform containing a list box. Such a list box can contain a practically unlimited number of items, each of hundreds of characters (not that it can show them all, because it won't scroll sideways). The Microsoft KnowledgeBase article http://support.microsoft.com/kb/198561 describes how to do it, and Greg Maxey's page at http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into more detail. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Thu, 11 Mar 2010 15:09:01 -0800, BDankas wrote: I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . |
#12
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
See http://www.gmayor.com/installing_macro.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I am not familiar with programming complex macros and the directions on the site are foreign to me (sorry). Do you have a step-by-step process?? "Graham Mayor" wrote: See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . |
#13
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
See http://www.gmayor.com/installing_macro.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I am not familiar with programming complex macros and the directions on the site are foreign to me (sorry). Do you have a step-by-step process?? "Graham Mayor" wrote: See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . |
#14
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
I have followed all the various websites and still don't understand.
Is there an easier way to do this?? "Graham Mayor" wrote: See http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I am not familiar with programming complex macros and the directions on the site are foreign to me (sorry). Do you have a step-by-step process?? "Graham Mayor" wrote: See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . . |
#15
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
I have followed all the various websites and still don't understand.
Is there an easier way to do this?? "Graham Mayor" wrote: See http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I am not familiar with programming complex macros and the directions on the site are foreign to me (sorry). Do you have a step-by-step process?? "Graham Mayor" wrote: See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . . |
#16
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
Unfortunately there is a learning curve to vba programming, however, a
similar study came up recently in the vba programming group and the solution I came up with could easily be adapted to your requirements, but it will require you to transfer some macros to your template and to add a userform. That thread can be seen at http://groups.google.com/group/micro...8968d?lnk=raot It would be far simpler and quicker for me to add the userform to the template than to try and explain it in simple terms - if you can send me your template to the link on the home page of my web site. I will need to know also the alternative texts associated with the paragraphs and whether the template is for your own use or will be distributed to others. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I have followed all the various websites and still don't understand. Is there an easier way to do this?? "Graham Mayor" wrote: See http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I am not familiar with programming complex macros and the directions on the site are foreign to me (sorry). Do you have a step-by-step process?? "Graham Mayor" wrote: See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . . |
#17
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
Unfortunately there is a learning curve to vba programming, however, a
similar study came up recently in the vba programming group and the solution I came up with could easily be adapted to your requirements, but it will require you to transfer some macros to your template and to add a userform. That thread can be seen at http://groups.google.com/group/micro...8968d?lnk=raot It would be far simpler and quicker for me to add the userform to the template than to try and explain it in simple terms - if you can send me your template to the link on the home page of my web site. I will need to know also the alternative texts associated with the paragraphs and whether the template is for your own use or will be distributed to others. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I have followed all the various websites and still don't understand. Is there an easier way to do this?? "Graham Mayor" wrote: See http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I am not familiar with programming complex macros and the directions on the site are foreign to me (sorry). Do you have a step-by-step process?? "Graham Mayor" wrote: See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . . |
#18
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
Thank you Graham! I have sent you the requested information
"Graham Mayor" wrote: Unfortunately there is a learning curve to vba programming, however, a similar study came up recently in the vba programming group and the solution I came up with could easily be adapted to your requirements, but it will require you to transfer some macros to your template and to add a userform. That thread can be seen at http://groups.google.com/group/micro...8968d?lnk=raot It would be far simpler and quicker for me to add the userform to the template than to try and explain it in simple terms - if you can send me your template to the link on the home page of my web site. I will need to know also the alternative texts associated with the paragraphs and whether the template is for your own use or will be distributed to others. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I have followed all the various websites and still don't understand. Is there an easier way to do this?? "Graham Mayor" wrote: See http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I am not familiar with programming complex macros and the directions on the site are foreign to me (sorry). Do you have a step-by-step process?? "Graham Mayor" wrote: See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . . . |
#19
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Drop Down Box Length
Thank you Graham! I have sent you the requested information
"Graham Mayor" wrote: Unfortunately there is a learning curve to vba programming, however, a similar study came up recently in the vba programming group and the solution I came up with could easily be adapted to your requirements, but it will require you to transfer some macros to your template and to add a userform. That thread can be seen at http://groups.google.com/group/micro...8968d?lnk=raot It would be far simpler and quicker for me to add the userform to the template than to try and explain it in simple terms - if you can send me your template to the link on the home page of my web site. I will need to know also the alternative texts associated with the paragraphs and whether the template is for your own use or will be distributed to others. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I have followed all the various websites and still don't understand. Is there an easier way to do this?? "Graham Mayor" wrote: See http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I am not familiar with programming complex macros and the directions on the site are foreign to me (sorry). Do you have a step-by-step process?? "Graham Mayor" wrote: See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "BDankas" wrote in message ... I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it. . . . |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down form field length | Microsoft Word Help | |||
Drop down form entry length | Microsoft Word Help | |||
How do I resize a drop down box length? | Microsoft Word Help | |||
Length of drop-down form fields. | Microsoft Word Help | |||
Drop Down Form Field length | Microsoft Word Help |