Formatting a Numbr in Forms and Reports

Copper Contributor

I've been trying to find something on this, but I'm continually running into dead ends.

 

On a form or report, I'd like to format a number so that it shows correctly.

 

The field is bound to a table, not a text field.

 

Take the number 1234.56 as entered into a field.  I would like for it to display 1,234.56.

 

If the number is 1234.5, I would like for it to display 1,234.5, not 1,234.50,

 

If the number is 1234, I would like for it to display 1,234, not 1,234.00.

 

So the format would need to adjust the decimal places as what is entered into the field.

 

Thanks in advance

 

Jeff

0 Replies