ivorykitten
Thu Jun 08 07:35:02 CDT 2006
That is super cool, thank you so much!
"Doug Robbins - Word MVP" wrote:
> OK, here's a way to do it.
>
> 1. Line up the formfield to a right aligned tab stop in the cell.
> 2. In the properties dialog of the formfield, set it to a number Number
> type, select the desired Number Format and check the Calculate on Exit box.
> Make a note of the name of the bookmark that is assigned to the formfield.
> 3. At the left of the cell, insert the following field construction:
>
> { IF { REF Text1 } > 0 "$" "" }
>
> replacing Text1 with the name of the bookmark assigned to the formfield.
>
> --
> 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
>
> "ivory_kitten" <ivorykitten@discussions.microsoft.com> wrote in message
> news:57215D91-35E7-451A-BBB0-48AB506DD25C@microsoft.com...
> > Except that when it's blank, the $ is still there and it looks odd!
> >
> > Can it be done or not?
> >
> > If it can't be done then I guess I will have to get over it!
> >
> > "Doug Robbins - Word MVP" wrote:
> >
> >> Why not just have the $ as regular text in the cell and position the
> >> formfield with a tab with it's formatting set so that it does not contain
> >> the $
> >>
> >> --
> >> 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
> >>
> >> "ivory_kitten" <ivorykitten@discussions.microsoft.com> wrote in message
> >> news:75DF0255-2D1B-4440-93D9-808B66058930@microsoft.com...
> >> > Yes I tried that, the switch does not seem to work after though.
> >> >
> >> > My field is {FORMTEXT}
> >> >
> >> > And I tried doing the switch {FORMTEXT \# "$[tab]#,#.00;-#,#.00;"} but
> >> > it
> >> > does not apply my formatting!
> >> >
> >> >
> >> >
> >> > "Doug Robbins - Word MVP" wrote:
> >> >
> >> >> Before you protect the document, use Alt+F9 to toggle on the display
> >> >> of
> >> >> the
> >> >> fields in the document and you will then be able to add the switch
> >> >> inside
> >> >> the closing }. Note, to avoid the dog's breakfast, you will have to
> >> >> have
> >> >> the paragraph format in the cells left aligned and use a right aligned
> >> >> tab
> >> >> stop. A decimal one will not work in these circumstances.
> >> >>
> >> >> --
> >> >> 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
> >> >>
> >> >> "ivory_kitten" <ivorykitten@discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:84762139-B9FF-40BE-8F1E-4F02ADB1996D@microsoft.com...
> >> >> > yes that's how i want it to look, but the fields are not regular
> >> >> > fields
> >> >> > they
> >> >> > are form fields {FORMTEXT} and it doens't work with switches (unless
> >> >> > i'm
> >> >> > doing it wrong?)
> >> >> >
> >> >> > I need to put the format in the dialog box "Text Form Field Options"
> >> >> >
> >> >> > Hope you can help!
> >> >> >
> >> >> > "Graham Mayor" wrote:
> >> >> >
> >> >> >> You want the dollar signs to line up and then tab to the numbers so
> >> >> >> that
> >> >> >> it
> >> >> >> looks like the following dog's breakfast?
> >> >> >>
> >> >> >> $ 5.00
> >> >> >>
> >> >> >> $ 75.00
> >> >> >>
> >> >> >> $ 135.00
> >> >> >>
> >> >> >> $ 25.00
> >> >> >>
> >> >> >> $ 6.00
> >> >> >>
> >> >> >> $ 87.00
> >> >> >>
> >> >> >> $ 9,876.00
> >> >> >>
> >> >> >> $ 675.00
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> In that case use the following switch:
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> \# "$' ',0.00"
> >> >> >>
> >> >> >> with a tab between ' '
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >> >> >> Graham Mayor - Word MVP
> >> >> >>
> >> >> >> My web site www.gmayor.com
> >> >> >> Word MVP web site
http://word.mvps.org
> >> >> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >> >> >>
> >> >> >>
> >> >> >> ivory_kitten wrote:
> >> >> >> > I have a table with a form field (for a user to enter a currency
> >> >> >> > amount) and
> >> >> >> > a calculation field in the row below and I want them formatted
> >> >> >> > the
> >> >> >> > same.
> >> >> >> >
> >> >> >> > I was hoping to be able to apply the switch from my calculation
> >> >> >> > field
> >> >> >> > to my form field but can't seem to figure it out!
> >> >> >> >
> >> >> >> > This is the switch: \# "$#,#.00;-#,#.00;" but there is also a tab
> >> >> >> > between $ and amount so that they line up nicely. Wasn't sure
> >> >> >> > how
> >> >> >> > to
> >> >> >> > show that in here.
> >> >> >> >
> >> >> >> > My calculation field works fine, but I can't figure out how to
> >> >> >> > use
> >> >> >> > the tab space with the form field!
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>