Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2003

Tip: Looking for answers? Try searching our database.

If...then..else - insert tab?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Patti - 26 Nov 2003 14:21 GMT
I am inserting a word field into my merge.  It is an if..then..else field.  If a certain field equals yes then tab.  How do I write this?  What is the designation for a tab?  I tried ^t but that did not work.
Cindy M  -WordMVP- - 27 Nov 2003 11:09 GMT
Hi =?Utf-8?B?UGF0dGk=?=,

> I am inserting a word field into my merge.  It is an if..then..else field.  If a certain field equals yes then tab.  How do I write this?  What is the
designation for a tab?  I tried ^t but that did not work.

It would basically look like this:

{ IF { Mergefield xyz } = "yes" "   " "" }

Where you actually press the TAB key where you want to have it.

If you're currently working in Word's If...then...else dialog box, type
anything you want where you need the TAB. Close the dialog box. Now press
Alt+F9 and you should see the field codes (as above). Select what the
placeholder, delete it, and press TAB. Alt+F9 again to hide the field codes.

Note: do NOT try to type the field code above from the keyboard. You can't use
{ } from the keyboard to insert field brackets. This can only be done by
pressing Ctrl+F9. These are actually special control characters that just look
like { }.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
Peter Jamieson - 27 Nov 2003 11:19 GMT
You put an actual tab character into the result text.

But it is probably easier to do this if you insert the IF field first
(however you are currently doing that) then use Alt-F9 to reveal the field
codes in your text and edit the result texts directly.

e.g. if you already have something like
{ IF { MERGEFIELD x } = "yes" "" "" }

then put the insertion point between the first "" and press the tab key
(unless the field is in a table, in which case use ctrl-tab).

As for checking for "yes", if it is literally "yes" then the above would be
OK. But if it could be Yes, yes or YES then you need something like

{ IF { MERGEFIELD x \*Upper } = "YES" "<a tab character>" "" }

Perhaps not relevant, but...

and if x is a Yesno field in Access you will probably need something more
like

{ IF { MERGEFIELD x } = 0 "" "<a tab character>" }

but you need to check exactly what values Word inserts for { MERGEFIELD x }
for the "True/False" values of x and test against that value in your IF
statement (because Word inserts different values for True/False, Yes/No
depending on how it connects to Access).
--
Peter Jamieson - Word MVP

> I am inserting a word field into my merge.  It is an if..then..else field.  If a certain field equals yes then tab.  How do I write this?  What is the
designation for a tab?  I tried ^t but that did not work.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.