flexgrid formatting 1

[cjac]

Hi, I am trying to format a flexgrid at runtime. I'm having a little trouble getting the effect I want. Here's what I've got:

For rowi = 1 To rScount
With fgTermCodes
.FillStyle = flexFillRepeat
.row = rowi
.col = 0
.ColSel = 3
.CellBackColor = &HC0FFFF
.CellFontBold = False
End With
Next rowi

For coli = 0 To 3
With fgTermCodes
.FillStyle = flexFillRepeat
.row = 0
.col = coli
.CellBackColor = &HC0C0C0
End With
Next coli

I basically want the top row to be in grey and the cells to have a 3D effect and the rest of the grid in yellow and have flat style gridlines. However, my first column has bold gridlines despite numerous attempts to reset this.

 

[cjac]

Further to the above, I do not seem to be able to format column 0. Is there a reason for this?

 

[cjac]

Maybe I should be a little more specific. What I want to know is can you set the gridline style for a particular cell or will this effect the whole of the grid? Simililary, can I give a specific cell a 3D effect?

Cheers

 

[zemp]

This works for me. You need to set the .rowsel property so a row is actually selected to apply the changes to.

   Dim i As Integer
   
   With MSFlexGrid1
      .FillStyle = flexFillRepeat
      .Row = 0
      .RowSel = 0
      .Col = 0
      .ColSel = .Cols - 1
      .CellTextStyle = flexTextRaised
     For i = 1 To .Rows - 1        
        .Row = i
        .RowSel = i
        .Col = 0
        .ColSel = .Cols - 1
        .CellBackColor = &HC0FFFF
        .CellFontBold = False
      Next i
   End With

The grid lines are set for the entire grid. The only difference is fixed rows or columns and non fixed rows or columns.


Take Care,

zemp

 

[zemp]

To set the style of a specific cell,

   With MSFlexGrid1
      .Row = 3
      .Col = 3
      .CellTextStyle = flexTextRaised
   End With

Take Care,

zemp

 

[cjac]

Thanks for the response zemp. However I am still having problems with this: my first column cell on my selected row does not fill despite the following code being in place:

With fgTermCodes
.FillStyle = flexFillRepeat
.row = curRow
.col = 0
.ColSel = 3
End With

Any ideas as to why my first cell on the selected row will not highlight?

Cheers

 

[zemp]

Is the first cell a fixed column? does that cell have the focus and does it have a focus rectangle? What is the selection mode for the grid? I usually have it set to selection by row and No focus rectangle. Try playing with those properties and see if you can get what you want.

Take Care,

zemp

 

[cjac]

Hit the nail on the head there zemp - fixed col and focus rectangle properties re-jigged and all is now well.

Cheers
cjac