1 Topic by geochrist (edited by geochrist 2019-12-15 16:24:31)

  • Registered: 2015-10-12
  • Posts: 84

Topic: How to colour a table grid row

Hi to all.

I have a tablegrid displaying fields from a database.
For example name,surname,year

I want to color the entire grid row when the value of the "year" field is equal to a particular number lets say 1970.
So in this case all persons in the database with year=1970 should have their corresponding grid rows coloured to a specific color such as green.

When looking at the table one can easily see what people are of the year 1970 since their rows will be green.

What script could I use?

Thank you
George

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: How to colour a table grid row

Try something like this (see attached).
Derek.

Post's attachments

Attachment icon yearborn.zip 338.09 kb, 674 downloads since 2019-12-16 

  • Registered: 2015-10-12
  • Posts: 84

Re: How to colour a table grid row

Thank you Derek.

That is what I was searching for. Instead of the search button I will run the code in the form show event.

Thank you for your help.
It is very nice to get answers to questions concerning MVD.