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

​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  Read More

​