A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Fill in the blanks



 
 
Thread Tools Display Modes
  #1  
Old September 1st, 2004, 11:52 PM
Signe
external usenet poster
 
Posts: n/a
Default Fill in the blanks

I am creating forms for a police department and have a
question. I am creating the forms with tables and using
form fields. I am wondering if it is possible to type in
one field and have another field automatically fill in
with text corresponding to what I typed in the first
field. For example- I type in an activity code in the
activity code field and I want the State statute that
corresponds with that activity code to automatically be
put in the state statute field. Is this possible?
  #2  
Old September 2nd, 2004, 03:04 AM
Jean-Guy Marcil
external usenet poster
 
Posts: n/a
Default

Bonjour,

Dans son message, Signe écrivait :
In this message, Signe wrote:

|| I am creating forms for a police department and have a
|| question. I am creating the forms with tables and using
|| form fields. I am wondering if it is possible to type in
|| one field and have another field automatically fill in
|| with text corresponding to what I typed in the first
|| field. For example- I type in an activity code in the
|| activity code field and I want the State statute that
|| corresponds with that activity code to automatically be
|| put in the state statute field. Is this possible?

Use {REF} fields where you want the repeated text.

E.g: On page one, you have a text field named "Text1" (right click the
field, click properties, and see/change the name where it says Bookmark,
bottom right corner).
everywhere else you want Text1 to appear do:
CTRL-F9;
A pair of { } will appear;
Type REF Text1 between the curly braces;
Create all the REF fields you want;
In the field where the text originates, make sure to check the "calculate on
exit" checkbox so that all REF fields will be updated automatically when
leaving the text fields;
Finally, do ALT-F9 twice to turn the REF fields into their values (They will
seem to disappear the first time as they will be linked to empty fields);
Lock the form;
Type some text in Text1;
See all the REF Text1 field update when you tab out of Text1.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org


  #3  
Old September 2nd, 2004, 07:46 AM
Graham Mayor
external usenet poster
 
Posts: n/a
Default

You can use the technique or a variation of it to insert the texts based on
the codes shown at http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Signe wrote:
I am creating forms for a police department and have a
question. I am creating the forms with tables and using
form fields. I am wondering if it is possible to type in
one field and have another field automatically fill in
with text corresponding to what I typed in the first
field. For example- I type in an activity code in the
activity code field and I want the State statute that
corresponds with that activity code to automatically be
put in the state statute field. Is this possible?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto fill criteria/questions on filling formulas down JAnderson General Discussion 2 July 19th, 2004 09:45 PM
Vlookup value from fill colour only. shital Worksheet Functions 1 June 7th, 2004 02:34 PM
Pivot Table - fill in the blanks Megan Worksheet Functions 4 March 22nd, 2004 09:07 PM
Changing fill color gradient on chart melissa Charts and Charting 1 February 21st, 2004 01:03 AM
fill in blanks michele Worksheet Functions 1 October 29th, 2003 01:38 PM


All times are GMT +1. The time now is 12:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.