I work for an international company. We have a standard form that is required to be filled in for salary increment requests.



Currently this is a restricted form, where only specific fields can be edited.

The salary field has a Number type, with Unlimited length and the format is

$#,##0;($#,##0)

This has the effect of converting whatever currency symbol is input into the dollar symbol.

Is there a way of editing this so that a currency symbol is mandated, but that can be ANY currency symbol, not just the dollar?

No. You have to specify the currency symbol as part of the currency format. If you want the user to be able to specify the currency as well, you could delete the $ from the current field and provide a dropdown formfield with a list of currency symbols to choose from. If you have multiple such fields, but they always use the same currency, the selection need only be done in one place - you can use the 'calculate on exit' property and cross-referencing to replicate the symbol in the other locations.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Gotcha, thanks!