Problem in Numeric Field

[jck_drmjn]

I have set a numeric field with following things:

Object > field > patterns > display > $1234.21

It works well but when I set expand fit width, it expands but not show "$" and " .00". It just show like 12340000000000.

Or sometimes It shows black + sign right bottom corner though it shows correct format. Where have I made a mistake?

In addition, I have set float type data format.

[radzmar]

Hi,

you pattern has not enough digits to match your input.

Change it to num{$ zzz,zzz,zzz,zzz,zz9.99}.

The 'z' is a placeholder for a number that can appear but don't has to.

[jck_drmjn]

Thanks a lot. That is perfect.

Little problem left. When I click in that field "0" is remained. I wish when I click in the field automatically "$0.00" will be removed but "$0.00" will show as a default.  Would you tell me what I can do?

[radzmar]

Add the same pattern as edit pattern.

[jck_drmjn]

I placed in edit pattern but now steady, not remove $0.00 automatically.

[radzmar · Accepted solution]

Hi, sorry I misunderstood your question.

1. remove the edit pattern

2. Add this script in the enter:Event

3. Add this script in the exit:Event

[jck_drmjn]

Hi radzmar,

Thanks a lot.