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.

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

Cheers.
aegean66
Occasional Contributor
Occasional Contributor
 
Posts: 20
Joined: Wed Mar 02, 2011 2:26 pm
Topics Solved: 1

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
Scott.Pearce
Jiwa Senpai
Jiwa Senpai
 
Posts: 625
Joined: Tue Feb 12, 2008 11:27 am
Location: North Sydney, New South Wales
Topics Solved: 182


Return to Technical / Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron