How can I change a colums font color

Hello all,
I hope someone smarter then myself can help.

I am using the following code to change the background of a Column as needed

But i can not work out how to set the font color (as For example on the red background black text is very hard to see my customers have said)

if someone would be as kind to show me how I can change the font color I would be most greatful.

Kind Regards
Andy

 

Hi Andy.

Does the format
Gridview[RowNo , ColumnNo].Foreground = Color.Red
not work ?



This works for me with Gambas 3.21.3 on Linux Mint 22.3

I, like Quincunxian, also run Linux Mint 22.3 and Gambas 3.21.3. I have come up with the following code that I have tested using gb.gui and gb.gui.qt and here is the result and the code.



Run the code in a Graphical Application. I hope it helps.

Quincunxian said

Hi Andy.

Does the format
Gridview[RowNo , ColumnNo].Foreground = Color.Red
not work ?



This works for me with Gambas 3.21.3 on Linux Mint 22.3

From “Post #14,213”, February 21st 2026, 6:13 PM

Hi Quincunxian
I am still using 3.19.5 as I have not worked out yet how to update the Database funtions to the new version that 3.2X uses so I do not have access to the .foreground option

Unless something changed for 3.19.5 it should be working.

I'm still on 3.18.0 and it works for me. I created a reminder calendar that's still running strong after 10 years that uses .Foreground, .Background, .Font.Size, .Text, .Alignment extensively - all without issue.

This is just one way I use .Background in my project to get it's data from a settings file.

sholzy said

Unless something changed for 3.19.5 it should be working.

I'm still on 3.18.0 and it works for me. I created a reminder calendar that's still running strong after 10 years that uses .Foreground, .Background, .Font.Size, .Text, .Alignment extensively - all without issue.

This is just one way I use .Background in my project to get it's data from a settings file.

gvCalendar[iRow, iCol].Background = MGlobal.hSetting["System/Calendar/Reminder", &H00FFFF&]    ' add color to reminder days

From “Post #14,217”, February 22nd 2026, 12:49 PM

That is really stange when I do use the .Foreground I get a error saying "Unkown Symbol 'Foreground' in class '_GridView_Column'


This is what I am using to create my gridview



and then I call this code


So what could I be doing wrong?





[reason for edit: cleaned up code to display better. second code block's indentation isn't correct.)

Since Gambas 3.1



You must be doing something wrong and the fact that you post your code in one long line doesn't really help.
If you post code and disabled WYSIWYG, you need to add '<br>' to the end of all your lines of code or else you get what you did, one long unreadble line with a for next loop.

I hope this help 

Edit:
I see you where talking about the Foreground and not the Backgound. My mistake.
GridView.Columns has no Foreground property, so don't even bother trying.

And GridView[0].Background = Color.Yellow works on Column level and will make ALL cells in Column 0 (first one) yellow.
Is that what you want? Example code and result screen below.





Foreground needs to be done on cell level with the GridView[iRon, iCol].
Background can be done in the same manner.

Do you use the Gridview_Data event to populate your GridView or do you use your own code loops? Just wondering.


 

gbWilly said

Since Gambas 3.1



You must be doing something wrong and the fact that you post your code in one long line doesn't really help.
If you post code and disabled WYSIWYG, you need to add '<br>' to the end of all your lines of code or else you get what you did, one long unreadble line with a for next loop.

I hope this help

Edit:
I see you where talking about the Foreground and not the Backgound. My mistake.
GridView.Columns has no Foreground property, so don't even bother trying.

And GridView[0].Background = Color.Yellow works on Column level and will make ALL cells in Column 0 (first one) yellow.
Is that what you want? Example code and result screen below.





Foreground needs to be done on cell level with the GridView[iRon, iCol].
Background can be done in the same manner.

Do you use the Gridview_Data event to populate your GridView or do you use your own code loops? Just wondering.

From “Post #14,234”, February 23rd 2026, 9:48 AM

I am using loops to populate the grid

so would frmDashBoard.GridViewLast7Days.Row[(i - 1)].Foreground = Color.Black work or am i on a copmpletely wrong trail of thought?

Also sorry about the code thing I am still getting use to the new website

AndyGable said

I am using loops to populate the grid
so would frmDashBoard.GridViewLast7Days.Row[(i - 1)].Foreground = Color.Black work or am i on a completely wrong trail of thought?

From “Post #14,235”, February 23rd 2026, 11:10 AM

If you type the last dot in frmDashBoard.GridViewLast7Days.Row[(i - 1)]. does the autocomplete with properties pop up (like in my earlier screenshot on Background)?
If not, then it probably can't be done. simple as that.

You need to set the Foreground at a cell by cell basis what should be easy in 2  For Next loops, one for colum index  (fields) and one for the row index (records)
frmDashBoard.GridViewLast7Days[iRow, iCol].Foreground = Color.Red will work for the cell in row iRow and column iCol. There is your solution.

It has all been demonstarted to you above exstensively. Did you take time to study and comprehend what was shown and explained to you (source package included to test).
I ask because you try to do other things than have been demonstrated and explained.

Quin posted: Gridview[RowNo , ColumnNo].Foreground = Color.Red
cogier posted: GridView1[iRow, iCol].Foreground + source archive to test and play for understanding the matter
You do: GridView.Columns[(i Row].Foreground = 
you posted: So what could I be doing wrong?
gbWilly answerd: Foreground needs to be done on cell level with the GridView[iRow iCol].
You do: GridView.Row[(iCol)].Foreground =
You ask: will above work or am i on a completely wrong trail of though
my answer: You either, don't read what has been answerd OR you don't understand what you read, as the answer has been given multiple times over, yet you try something else, that nobody here advised 


Enjoy…

 

This is the code for the config panel. It gives a "live" preview for setting the GV colors for the backgroun and, current day border.

calendar_config.png

(Click to enlarge)

   

calendar_config_live.png

(Click to enlarge)

This code builds the calendar and sets the background color for the day where there is an entry. The code also sets a border color around the current day. The original version would change background colors depending on how close to the day the event is. These colors are set in the config panel and saved to a settings file.

Startin on line 78 is the code that does most of the work.

calendar.png

(Click to enlarge)

(If I remember correctly gbWilly helped with figuring out a few things with the functionality of the calendar.   )

AndyGable said

Also sorry about the code thing I am still getting use to the new website

From “Post #14,235”, February 23rd 2026, 11:10 AM

No worries. I'll see what I can do to clean up your post to display the code better.

As gbWilly said, disabling the WYSIWYG editor makes life a little easier for posting code.

If you're not sure how to disable the WYSIWYG editor, and you haven't seen the tutorials forum, there are a few tutorials that might help to make posting a little easier. Editors,  Post Templates, Gambas Code Syntax Highlighting. There is also a Playground if you're feeling adventurous and want to test out the different functions of the editor.

sholzy said

(If I remember correctly gbWilly helped with figuring out a few things with the functionality of the calendar.   )

From “Post #14,237”, February 23rd 2026, 2:18 PM

Seeing the names of several of the variable names used (my trade mark so to speak) and the approach method, I would say you are correct, even if I don't remember anymore, must have been at least 10 plus years back in time

          

gbWilly said

sholzy said

(If I remember correctly gbWilly helped with figuring out a few things with the functionality of the calendar.   )

From “Post #14,237”, February 23rd 2026, 2:18 PM

Seeing the names of several of the variable names used (my trade mark so to speak) and the approach method, I would say you are correct, even if I don't remember anymore, must have been at least 10 plus years back in time

From “Post #14,239”, February 23rd 2026, 3:25 PM

Looking at the build logs… the first build was May 4, 2016. 10 year anniversary coming up!   

Public Sub ChangeColumnForeground(iColumn As Integer, iColor As Integer)
  Dim iRow As Integer
  For iRow = 0 To Gridview1.Rows.Max
    Gridview1[iRow, iColumn].Foreground = iColor
  Next
End

THANK you for that Cogier that worked perfectly that so I have add one option and now it works for all my griviews that I need to upate the font color

I added Gridview1 As GridView and when I call it now i use

ChangeColumnForeground(frmDashBoard.GridViewLast7Days, (i - 1), Color.Black)

SORRY I was not understanding but I did try everything everyone was showing me on the fourm but as normal Gambas was showing me errors on the thigs I tried.
I also could not understand how to do the change cell by cell and thanks to Cogier I understand how to to it now so I can update my other Form where needed