Column Size

[briggsy79]

Hi everyone,
I was wondering if/how you can set the column width for a MSFLexiGrid for individual columns
i.e., i want to have a small one for the id number
Any help would be greatly appreciated, Thanks

 

[JohnYingling]

Here is how I do it. I have the grdDep defined with Font=Courier (Fixed length).
With grdDep
.Clear
.FixedCols = 0
.FixedRows = 1
End With

.Rows = 1 ' Allocate row for header

.ColAlignment(DepProdType) = flexAlignLeftCenter
.FormatString = "RowType|Deposit Acct Type|Rel| Account Number" & _
"|Status|>Avg Bal/YTD|> Curr Ledger|> Curr Avail"

 

[JohnYingling]

Move that End With down a bit.