Fillin field or equivalent

[John Davidson]

Hi All,
Is there an option available to automatically disable fill-in field
prompts once they have been filled, or is there a similar feature to
achieve this.
I want to ensure my users fill in the required fields but once filled,
do not want them to be prompted again and again and again.
Any suggestions would be appreciated.
TIA John D.

 

[Anne Troy]

Use form fields.
http://www.theofficeexperts.com/word.htm#Fill-inForms
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************

 

[Joey Jacobs]

I have written a macro which searches for each fill-in
field when you create a document based on a specific
template, it then prompts you for the fill-in info which
must be typed in and clears the field automatically. Its
like a counter searching from beginning to end of file. If
you haven't managed as yet, let me know and I can explain
in detail.

 

[Joey]

Further to my previous response:

The other thing you can do is after completing the fill-in
fields, clear all fields by selecting the whole document
and pressing Ctrl+Shft+F9. BE CAREFUL as when you have
cross referencing in that document, it will also clear
your cross reference fields and that is why my previous
mail stating about the counter works better as it clears
field by field and not your entire document at once. If
you clear the entire document, you table of contents will
also no longer update automatically (should you have one.

 

[macropod]

Hi John,

This is relatively easy with an ASK field, and could be adapted to work with
a FILLIN field. Here's some instructions on how to modify a .dot file, using
an ASK field instead of a FILLIN field:

1. In the template, create an ASK field in the format:
{QUOTE{IF{BkMrk}= "" {ASK BkMrk "Put your prompt here"} ""}{BkMrk}}
where 'BkMrk' is an arbitrary bookmark name.

2. Then, at the start of the field, create an empty bookmark corresponding
to whatever you call 'BkMrk'. You can do this via Insert|Bookmark (with
nothing selected).

3. Save the template. Don't answer the question before saving the template,
otherwise you'll have to delete the bookmark and re-create it.

Now, when the fields in a document based on the template are updated (eg via
printing), users will only be prompted to respond to the ASK field if they
haven't already done so.

Cheers

 

[John Davidson]

Thanks Guys,
I will have a look at all your suggestions, but I like the idea of a
form that pops up by some sort of event and clears the field once the
fields have been filled.
Thanks,
John D.

 

[Greg]

Macropod,

Fine piece of work

ASK fields won't automatically fire when a new document is
created from a template containing the ASK field. This
means that without manually updating the fields, the user
wouldn't see the prompt until time of print and perhaphs
not then in update fields is turned off as a print
option. I suggest the following modification:

{QUOTE{IF{BkMrk }=""{SET BkMrk {FILLIN "Yourprompt."}}""}
{BkMrk}}

By using a Set and Fillin field, the prompt will fire when
a new document is created.

 

[macropod]

Hi Greg,

Given that this is a vba forum, and not wanting to detract from your
suggestion, an AutoNew macro with an ActiveDocument.Fields.Update statement
would achieve that result also.

Cheers

 

[Greg Maxey]

Macropod,

That is true and I use that method myself. As some folks try to avoid
macros your idea combined with my suggestion simply provides another
alternative.