Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

One-Time Only "Ask" Field

Posted on 2007-11-14
4
439 Views
Last Modified: 2008-02-01
I have a template with an ask field such that when a user creates a document based on the template and ask field pops up with a question.  The question is pre-filled with the most common answer to the question. There are two things I'd like to improve, but am not sure how to.

First, once the document is saved, each time it is reopened, the ask field pops up again.  I'd like it so that the only time they get the question asked is upon creating a brand new document based on the template.  

Secondly, the ask field really has two valid answers.  One of the answers, which is the one I have defaulted, is much more common than the other.  Yet, it would be nice to instead have some kind of picker with the 2 options, rather than making the person type the second one by hand if the default isn't correct.  

Help with either or both would be much appreciated.

Phil
0
Comment
Question by:witzph1
  • 2
4 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 20290942
I thought I see how to do that if you do not have a default choice, by nesting  the Ask field in an IF field that tests the bookmark for blank. However that acts weirdly. It does ask the question once only, but it moves the bookmark into the fields and forgets about the text that the user has just typed in.

The only getround that I can think of it to use a VBA macro firing off the Document_New event
0
 
LVL 21

Expert Comment

by:EricFletcher
ID: 20292203
I concur with Graham about having Word run a macro when the template creates a new document. You would probably have more latitude in dealing with the question if you used VBA code than having everything in an ASK field. I'm always leery of using content that a user can type over -- intentionally or otherwise.
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 20292683
This question shows how to do that sort of thing in VBA code:

http://www.experts-exchange.com/Programming/Misc/Q_22594246.html
0
 

Author Comment

by:witzph1
ID: 20424088
Thanks again, GrahamSkan.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you work with Word a lot, you probably use styles. If you use styles a lot, you've probably balled your fist more often than not when working with the ribbon. In Word 2007/2010, one of the things that I find missing when using styles is a quic…
Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question