Conditionally Format Text Box's Format Property

[kd2017]

Post title is a mouth full, sorry about that.



Is it possible to conditionally format a textbox's Format property in a continuous form?

For example using the table below, I'd like the Qty field in rows with 'FEET' units to be formatted as Standard w/ out decimals.
With 'PERCENT' to be formatted as a percentage.

Qty  | Unit
-----+--------
1.10 | FEET
0.10 | PERCENT

BECOMES

Qty  | Unit
-----+--------
1    | FEET
10%  | PERCENT

Ideas?

[orange]

Is Qty a number data type? If so, you could try Int(Qty)

For Percent 100*Int(Qty))

[Gicu]

Replace the control property with a calculated expressions that uses the Format() function to format the QTY based on your needs:

FORMATED_QTY: IIf([UNIT]="PERCENT",Format([QTY],"Percent"),Format([QTY],"Standard"))

Cheers,

[kd2017]

I should add that the control should remain editable.