ValidateCell (windowRef, listRef, rowNum, columnNum, cellValueString)

A script handler you can implement to override standard MoneyWorks behaviour.

Automatically called:  When a cell in an editable list (such as the detail line entry list) is about to be exitted. Row and column numbers are zero-based. Return 0 if the cell value is not acceptable: this will keep the focus in the cell. IMPORTANT: If you do this you should provide an explanation to the user via an alert or coachtip. Users will be very unhappy if they don't know why they can't exit a cell!

Use for:  Validating the content of a cell.

Return value:  Boolean

Specific Naming You can and should implement an ValidateCell handler that is specific to the particular window ID, itemID and possible column name of interest. e.g. ValidateCell:<WindowId>:ListItemID:ColumnName.

See Also:

AddListLine: Add a row to an editable list

DeleteListLine: Delete a row from an editable list

EnterCell: A cell in an editable list has just gained focus

ExchangeListRows: Swap rows in an editable list

ExitedCell: A cell in an editable list has just lost focus

GetActiveListColumn: Get the column number of an edit list that has keyboard focus

GetActiveListRow: Get the row number of an edit list that has keyboard focus

GetListField: Get the text of an editable list field

GetListHandle: Get list handle from window handle and list ident

GetListLineCount: Get number of rows in a list

GetListName: Selected tab name for Transaction entry details list

MergeOrderLines: Merge order lines (opposite of SplitOrderLines)

SetListField: Set the text of an editable list field

SortListByColumn: Sort an editable list by a column

SplitOrderLine: Duplicate a line item on an order, splitting the order qty (for serial entry)