Changing colour of line depending on product

Discussions relating to breakout scripting, .NET and COM programming with Jiwa objects.

Changing colour of line depending on product

Postby aegean66 » Fri Sep 18, 2020 12:17 pm

HI guys

Not overly hopeful on a response but;

How to I get to the properties of a line on a quotes text colour depending on part number.

If PartNo = "ABC123" then
Make the text colour of this line blue (or background colour)

Occasional Contributor
Occasional Contributor
Posts: 29
Joined: Wed Mar 02, 2011 2:26 pm
Topics Solved: 2

Re: Changing colour of line depending on product

Postby Scott.Pearce » Mon Sep 21, 2020 11:26 am

Put this in the "Form GridLines Displayed" breakout section:

Code: Select all
If FormObject.GridManager.GridText(FormObject.grdLines, "PartNo", Row) = "1171" Then
    FormObject.grdLines.Col = -1
    FormObject.grdLines.Col2 = -1
    FormObject.grdLines.Row = Row
    FormObject.grdLines.Row2 = Row
    FormObject.grdLines.ForeColor = vbBlue
End If

Note. The SalesOrderLineObject that is passed in to that breakout point is Nothing for me, which is why I'm using the grid object to get the part no. Must be an old bug.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Jiwa Senpai
Jiwa Senpai
Posts: 673
Joined: Tue Feb 12, 2008 11:27 am
Location: North Sydney, New South Wales
Topics Solved: 198

Return to Technical / Programming

Who is online

Users browsing this forum: No registered users and 1 guest