Hi all.

SLX LAN v7.2.1

I'm creating a datagrid using code and I want to know how I can round my currency field to 4 decimal places. Below is the code I'm using to make the column into currency but how do I make it so it rounds to 4 decimal places instead of 2 (default).

Thank you in advance!

            Set col = .Add(0)
             col.FieldName ="Carrier_Price"

             col.Caption = "Carrier Price" 

             col.Readonly = True
             col.FormatType = ftCurrency
             col.Width = 70
             col.Alignment = 2
             col.HeaderAlignment = 2

Thanks for the reply Mike.

I looked for "modify opportunity products" in the Scripting & Customization forum but couldn't find any thread where the decimal places for ftCurrency is set. I also tried your suggestion of .DecimalPlaces = 4 and that didn't work it gave me an error.

Yep, definitely was that:

            col.DecimalPlaces = 4 '<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
            col.DisplayFormat = ",0.0000;-,0.0000"  'DNL '<<<<<<<<<<<<<<<<<<<<<<

Mike

I tried using col.DecimalPlaces but I got an error: Object doesn't support this property or method: col.DecimalPlaces

So I got it to round to 4 decimal places with the following code:

             col.FormatType =  ftCurrency
             col.FormatString = "%.4m"

Thanks for your help Mike!