Flexgrid Column Name

G'day,

I've searched and searched and tried different properties, but still can't do it.

How do I give a msflexgrid or mshflexgrid a column name without getting it from the datasource. I want different names to what is available in the database.

Peter

The easy way is to create some alliases while building sql statement so column names will appear in the way you want:

VB Code:

strSQL = "Select OrderID As [Order Id], Freight As [Total Freight] from Orders"
    
    Set adoRst = New ADODB.Recordset
    With adoRst
        .CursorType = adOpenKeyset
        .LockType = adLockOptimistic
        .Open strSQL, adoConn, , , adCmdText
    End With
    
    HFGrid.Clear
    Set HFGrid.Recordset = adoRst

NOTE: sql will vary depending on the database you might have (sample above is for Access 2K).

When we do a SELECT that we know is going into a FLEXGRID (we use STORED PROCEDURES) - we do something like this:

Code:

---

SELECT column1 "Heading for Column 1 - extra spaces                          "
          ,column2 ">Heading for Col 2 - right justified"
          ,column3 "^Heading for Col3 - centered"
          FROM...

---

Then in the VB side, we use the .FORMATSTRING property of the flexgrid to build the headings from the COLUMN NAMES of the RECORDSET.

We also put special tokens in place sometimes - heading like "~wide~Heading". When the VB-side sees "~wide~" is searches all the cells in that column for the widest entry (using .TEXTWIDTH) and then forces that column to be that size - in TWIPS.

We have dozens of these special tokens.