Formatting a field.

[tmas73]

How can I format a field that when I enter like 500 into a field it automatically adds a g to the end, so the result is 500g. I tried the Calculated Value (""+g) but that wont work. How can I do it?

Thanks

[Inky Phil]

You can format the field to display the 'g' without storing it.

In layout mode, select the field inquestion and go to format drop down menu>number>currency trailing and set the currency symbol to'g'

hth

Phil

[Lee Smith]

Conditional Formatting is a Version 9 Feature.

Try using the Auto Enter Option for the field.

In [color:blue]Define Fields

Highlight the field

Click on Field [color:blue]Options

Click on [color:blue]Auto Enter Tab

Click on [color:blue]Calculated Value

Calculation is YourField & "g"

Click on [color:blue]Okay

[color:blue]Deselect the checkbox

"Do not replace existing value (if any)

Click [color:blue]Okay

HTH

Lee

[tmas73]

You can format the field to display the 'g' without storing it.

In layout mode, select the field inquestion and go to format drop down menu>number>currency trailing and set the currency symbol to'g'

hth

Phil

Hi thanks, what I did not mention was. I have a preference panel where the user can put custom weights for example he can use gram or oz or drops. So the calculation reveres to a preference fields and adds its content to the end.

Thanks for the help!

[Lee Smith]

That was important oversight.

Disregard the Auto Enter here, this will require a calculation Field.

Your calculation will be a concatenation of the two fields

Field one & Field two.

HTH

Lee