Form fields & calculation field formats

[ivory_kitten]

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!

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[ivory_kitten]

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!

 

[Doug Robbins - Word MVP]

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]

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]

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

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!

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]

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!

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

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!

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

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!

:

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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!

 

[Doug Robbins - Word MVP]

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

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!

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

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!



:

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

message
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!

:

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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!

 

[ivory_kitten]

That is super cool, thank you so much!

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

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!

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

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!



:

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

message
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!

:

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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!