Method Community

How can I make the balance field in the bill screen to show like this:   $ 1,523.00

Hi Marcelo,

Which screen and field are you referring to? I don't have a "Balance" field on my Bills screen.

- Justin

It is a cuztomized screen based on the credit card charge table, the balance field it is a linked field from the account table

Marcelo,

On Step 1 of 5 for your Balance field's Properties, you can set the text to "Bold" under "Formatting" and "Read Only" under "Advanced Options".

Hope this helps.

- Justin

Not just bold, I want the $ intead of USD and the comma for the thousands

Marcelo,

You could change your Default Currency Symbol to $ from the Customize > Display screen in Method. This would be system-wide, but it's the easiest way to get this done.

As far as the comma is concerned, it wouldn't be very straightforward. You could pull the value from the Balance field and assign it to an Action Result, then use the Character Function to manipulate it. You'd have to use Get Length and use a Basic Math Function to determine how many times to run a Get Right, separating the number in to Action Results of 3 characters each. You could then join them with commas and insert them into a Label on screen. You'd have to add a $ to the string as well in this case.

Hope this helps.

- Justin