I have created a custom search option but not sure how to set the qty's and $ as numbers instead of txt.
How can I make the Qty’s and Cost show formatted to 2 decimal places.
'tony add second one
SQL = "SELECT InventoryID, PartNo, Description, Lcost, QuantityLeft, QuantityAllocated, Warehouse, BinLoc "
SQL = SQL & " FROM View_CouplersStockSearchWithBin "
OrderBy = "ORDER BY PartNo"
Set AOption = CreateObject("JiwaSearch.SearchOption")
With AOption
.Title = "Part and Bins"
.SQLStr = SQL
.OrderBy = OrderBy
.AddColumn "InventoryID", vbString, "", 0, 1
.AddColumn "PartNo", vbString, "", 10, 5
.AddColumn "Description", vbString, "", 10, 2
.AddColumn "LCost", vbString, "",10, 2
.AddColumn "QuantityLeft", vbString, "", 10, 2
.AddColumn "QuantityAllocated", vbString, "", 10, 2
.AddColumn "Warehouse", vbString, "", 10, 2
.AddColumn "BinLoc", vbString, "", 10, 2
End With
JiwaSearchObject.Options.Add AOption
Set AOption = Nothing