MSFlexGrid Row Colour
Iím using an MSFlexGrid with a SQL RecordSource to display information from
an MSAccess Database.
Is it possible to highlight rows(change back colour)in the MSFlexGrid that
meet a condition?
I'd be grateful if anyone could help
Re: MSFlexGrid Row Colour
"Chris Zammit" <firstname.lastname@example.org> wrote:
>Iím using an MSFlexGrid with a SQL RecordSource to display information from
>an MSAccess Database.
>Is it possible to highlight rows(change back colour)in the MSFlexGrid that
>meet a condition?
>I'd be grateful if anyone could help
Chris, you can do something like this:
.Row = 4 ' the row you want to highlight
For i = 0 To .Cols - 1
.Col = i
.CellBackColor = QBColor(14)
Hope this helps. Josko
hi i have the same problem, however i want to highlight duplicate rows. i'm using ms access and vb6 what i want is when the user click the save button the program will search first for the duplicate error in msflexgrid and database and if there are duplicate records then the duplicated row will change background color to identify it.
Wouldn't it be less good, and make more sense, to simply not save the record at all into either the database or the grid. If you identify a new record as a duplicate, just pop up a message box telling the user that, and that it won't be saved.
Originally Posted by enigmagirl122
I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
Please use [Code]your code goes in here[/Code] tags when posting code.
Before posting your question, did you look here
Got a question on Linux? Visit our Linux sister site.
Modifications Required For VB6 Apps To Work On Vista
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center