Show/hide dropdown boxes
in [Word VBA]
|
Prev: Delete Inline Shape Problem
Next: Convert to PDF
From: Vinnie on 27 Oct 2009 11:16 Hello all, I have created a word document that has several dropdown boxes in it (who are filled from an sql database). 1) i would like that when a user wants to print the document, that those dropdownboxes are not printed 2) i would like to create a toolbar with a button to show/hide the dropdownboxes Could anyone put me into the right direction. Thanks already, Vincent
From: Doug Robbins - Word MVP on 27 Oct 2009 19:45 I would suggest that you should be using a UserForm, rather than inserting the dropdown boxes into the document. See the article "How to create a Userform" at: http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm and the following pages of fellow MVP Greg Maxey's website : http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm -- Hope this helps Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to avail yourself of my services on a paid, professional basis. "Vinnie" <Vinnie(a)discussions.microsoft.com> wrote in message news:C2C10A3A-6904-4DE4-B827-B77110E4959F(a)microsoft.com... > Hello all, > > I have created a word document that has several dropdown boxes in it (who > are filled from an sql database). > > 1) i would like that when a user wants to print the document, that those > dropdownboxes are not printed > > 2) i would like to create a toolbar with a button to show/hide the > dropdownboxes > > Could anyone put me into the right direction. > > Thanks already, > Vincent
From: Vinnie on 28 Oct 2009 04:15 Hello Doug, Thanks already for your reply. Do you mean that the manipulations i would like to do are not possible outside a userform ? Greetings, V.
From: Doug Robbins - Word MVP on 28 Oct 2009 15:32 What manipulations? What is the purpose of the dropdowns? If they were FormField dropdowns as used in a document that is protected for filling in forms, they do not appear as dropdowns when the document is printed, just the item selected in the dropdown will appear. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Vinnie" <Vinnie(a)discussions.microsoft.com> wrote in message news:BE0ABA99-E214-431E-AD25-B22CE963031B(a)microsoft.com... > Hello Doug, > > Thanks already for your reply. > > Do you mean that the manipulations i would like to do are not possible > outside > a userform ? > > Greetings, > V.
From: Vinnie on 29 Oct 2009 02:21
Hello Doug, Let me rephrase my question a bit clearer :) The dropdownboxes are not meant to be on a form, they are there to let the user select predefined text that is stored on a sql database. when the user selects an item in a dropdownbox, it is automatically filled in (also by script of course) in a bookmark under the dropdown. Now what i would like is to be able to hide the dropdowns: - when the document is printed (or make sure that they do not appear on the printout). Is this possible (with having to create a form)? Thanks, |