Changing the presentation mask of a field within a accpacviewlist

[ryslepel]

Is it possible to change the presentation mask of a field when using an accpacViewList.

I would like to change something trivial like changing an amount from 3 decimal places to two decimal Places.

Please Help

 

[ryslepel]

When you do the column names set the allow custom data to true.

Then add following function

Private Sub grdCredit_OnSetCustomItemData(ByVal bstrColName As String, ByVal bstrFieldName As String, pvBookMark As Variant, bstrData As String, pAccpacDSFields As Object)
bstrData = Format(pAccpacDSFields.Item("TRANSAMT").Value, "###,###,###,##0.00")
End Sub

Solved my own little problem.