3 Digit Decimal on Currency Field

[mar]

I added a text field to the [Add Edit Product] Form and set the FormatString to %.3f but the three decimal doesn't stick when the cursor lands on the field. ... it basically changes to currency format with two decimals and a dollar sign. The field/Form is not bound to the table and the field is of type Currency (numberic(17,4),null). Any workaround for this?

Thanks.

[MikeSpragg]

You need to change the formatting via code (shown below)


Form: Add Edit Product (if you want to change the Tools | Manage Products | Add Pricing)
----------------------------------------------------------------------------------------

Sub DefinePriceGrid ( )

'Price column
Set col = .Columns.Add(13)
col.FieldName = "PRICE" 'DNL
col.Width = 70
If GetMCValue(MC_On) = "T" Then
col.DisplayFormat = ",0.0000;-,0.0000" 'DNL
col.Caption = Application.Translator.Localize("Price") & " (" & GetMCValue(MC_BaseCurrencyCode) & ")"
Else
' col.DisplayFormat = "$,0.00;$-,0.00" 'DNL
col.Caption = Application.Translator.Localize("Price")
col.DecimalPlaces = 4 '<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
col.DisplayFormat = ",0.0000;-,0.0000" 'DNL '<<<<<<<<<<<<<<<<<<<<<<