MSFLEXGRID Problems

I can't figure out why for the life of me I can't use textmatrix (or seemingly any other code) in my code to change things in the flexgrid when the program runs. I am using VB5. I load info from an Access 97DB into a data control which is the data source for the flexgrid. The problem is that I do not like the headers from the database and that things are not aligned. I have managed to change the headers using SELECT..as method but I cannot align anything. Nor can I change what's in the grid boxes by using TextMatrix. Here is my code, maybe someone can help me out.

'Grid is named EmployeeGrid - Cols are set to 19, Rows to 16 and FixedCols to 0 and FixedRows to 1 at design

Data1.Connect = ";PWD password"
Data1.DatabaseName = frmMain.txtOpenFile
Data1.RecordSource = ("SELECT JobTitle As Job, PersonName As Name....FROM Employees WHERE DepartmentID =" & txtCurrentDepartment.Text)


Then it seems that code is useless. EmployeeGrid.TextMatrix(3,3) = "HERE" does nothing.

EmployeeGrid.FormatString = "^Job |<Name......." does not align the fields or change the headings if I didn't use SELECT...as above. It's like the grid won't respond to anything. I tried just a new project with a FlexGrid and no data source and just using TextMatrix and I can get that to fill in boxes and stuff but why won't it (or anything else) work here? I'm in desperate need of help. Thanks

bump to top...

anyone have any possible solutions?

CoachG,

You have not posted any MSHFlexGrid code. It would seriouly help if we knew just what did not work.

It's all in the code, no magic wands!!