find merge field length

[Raul Bloodworth]

Trying to do an if...then...else inside a telephone number merge field (or
vice versa).

Simply, if the merged phone number is greater than eight characters in
length I'd like the area code included for MY phone..

{ IF (LEN{ MERGEFIELD PHONE }>8) "212-" ""} 555-1234}

variants of the above don't work. Any ideas? TIA

 

[Peter Jamieson]

You probably won't be able to do this in Word unless the phone number only
contains digits, but you might be able to use some SQL to derive the
necessary info. from the data source. But which version of Word, and what
(format) is the data source?

 

[Raul Bloodworth]

Word XP, Access XP (formatted as text, no mask)

You probably won't be able to do this in Word unless the phone number only
contains digits, but you might be able to use some SQL to derive the
necessary info. from the data source. But which version of Word, and what
(format) is the data source?

 

[Peter Jamieson]

Try creating a query in Access based on the table or query you are currently
using, and add a derived column that does the whole thing, e.g.

iif(len(phonenumberfield) > 8, '212-555-1234', '555-1234') AS 'myphone'

 

[Peter Jamieson]

Sorry, you need backwards quotes for the fiel name I think:

iif(len(phonenumberfield) > 8, '212-555-1234', '555-1234') AS `myphone`

 

[Raul Bloodworth]

myphone: IIf(Len([PHONE])>8,"212-555-1234","555-1234") worked. Thanks for
the tip!