MSFlexGrid Fixed Row

[TonyJJ]

When loading a form containing an MSFlexGrid and a data control, the data control RecordSource field names are automatically included in the first fixed row. Redefining the text in the first fixed row can be achieved by code such as ...

msfgObject.row = 0
msfgObject.col = 1
msfgObject.Text = "Header Title"

BUT this method doesn't seem to work in the form load event, although it will work on any subsequent event on the form.
Any suggestions for loading headers on msFlexGrids at form load()??? <IMG SRC="http://216.167.2.32/ubb/smile.gif">

[JHausmann]

Your select statement can populate the headers as well.


for example:

select empno as "Employee Number", deptno as "Department", salary as "Gross Income" from payroll

[Emon]

try using a string variable in place of "Header Title"