Numeric Fields

[tlw444]

Newbie needs help. I can't figure this out. My form has simple calculations on it.

EXAMPLE: 1 +1=$2.00

This works fine as long as the user doesn't enter over $10,000.00.

When the user enter over 11,000.00 it changes the pattern to whole numbers without a dollar sign.

This is how I have my pattern set ($z,999.99).

I tried setting the display patterns, I can't get it to work, please help!

You can see my form here. http://www.gcfa.org/PDFs/FundBalanceReport.pdf

Thanks in advance for your help. :~)

[Raghu_Nagireddy]

In the form almost all having the pattern of $z,zz9.99 - so u can able to enter max 4 digit number.

if u want more can go with this: ($z,zzz,zzz,zz9.99), if it nver be -Ve number u can remove braces.

Also form did't have enough space to appear the big numbers.

Raghu.

[tlw444]

Yeah, I just now figured it out. The pattern is this $z,zzz,zz9.99 Thanks for your help.

[tlw444]

Thanks again, your help is greatly appreciated. I would give you credit for answering the question but I don't see where I can do it in the forum.