Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
raj
 
Posts: n/a
Default check to see if field is #

i need to check to see if a field is numeric. if it is apply the mask
otherwise just leave it as it is

i have this

{ if { MERGEFIELD "TEST" } "A" "{MERGEFIELD "BLAH" "mask=$#,##0"}
"{MERGEFIELD "BLAH"} }

please help


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default check to see if field is #

A formatting switch of the type \# "$#,##0" will be ignored if the field is
not numeric.

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"raj" wrote in message
...
i need to check to see if a field is numeric. if it is apply the mask
otherwise just leave it as it is

i have this

{ if { MERGEFIELD "TEST" } "A" "{MERGEFIELD "BLAH" "mask=$#,##0"}
"{MERGEFIELD "BLAH"} }

please help



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
raj
 
Posts: n/a
Default check to see if field is #

i am sorry but it does not
it acutally gives syntax error


"Doug Robbins - Word MVP" wrote in message
...
A formatting switch of the type \# "$#,##0" will be ignored if the field is
not numeric.

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"raj" wrote in message
...
i need to check to see if a field is numeric. if it is apply the mask
otherwise just leave it as it is

i have this

{ if { MERGEFIELD "TEST" } "A" "{MERGEFIELD "BLAH" "mask=$#,##0"}
"{MERGEFIELD "BLAH"} }

please help





  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default check to see if field is #

Not for me it doesn't. What are the contents of the field that causes the
problem and exactly what is the construction of the field that you are
using - that is what is contained inside the field delimiters { } that
are display when you select the field and Press Shift + F9 or use Alt + F9
to display all of the field codes.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"raj" wrote in message
...
i am sorry but it does not
it acutally gives syntax error


"Doug Robbins - Word MVP" wrote in message
...
A formatting switch of the type \# "$#,##0" will be ignored if the field
is not numeric.

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"raj" wrote in message
...
i need to check to see if a field is numeric. if it is apply the mask
otherwise just leave it as it is

i have this

{ if { MERGEFIELD "TEST" } "A" "{MERGEFIELD "BLAH" "mask=$#,##0"}
"{MERGEFIELD "BLAH"} }

please help







  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default check to see if field is #

Are you inserting the correct switch or your own made up switch from the
original post?

{Mergefield blah \# "$,0"}


--

Graham Mayor - Word MVP

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


raj wrote:
i am sorry but it does not
it acutally gives syntax error


"Doug Robbins - Word MVP" wrote in message
...
A formatting switch of the type \# "$#,##0" will be ignored if the
field is not numeric.

See "Formatting Word fields with switches" on fellow MVP Graham
Mayor's website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"raj" wrote in message
...
i need to check to see if a field is numeric. if it is apply the
mask otherwise just leave it as it is

i have this

{ if { MERGEFIELD "TEST" } "A" "{MERGEFIELD "BLAH" "mask=$#,##0"}
"{MERGEFIELD "BLAH"} }

please help



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I enter a check in the checkbox field Tricia Microsoft Word Help 3 August 23rd 05 08:09 AM
How can I check spelling in a text field form in Word 2003? Fred Microsoft Word Help 1 June 21st 05 04:22 PM
How do I get all my Word documents within one Word window RobJacobs Microsoft Word Help 5 April 12th 05 03:04 AM
check box form field, how do I "check" using Enter Key robanddawnmc Microsoft Word Help 4 April 6th 05 11:11 PM
Putting an actual check mark in a check box form field. Margot Microsoft Word Help 2 February 21st 05 09:59 PM


All times are GMT +1. The time now is 03:37 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"