Another MSFlexGrid questions(s)

[mecca]

My Flexgrid is working beautifully. However, how can I set a specific column width? In addition, is it possible to click on a row, then click a command button and open a new form and display that particular record?

[Serge]

Sure.


MSFlexGrid1.ColWidth(0) = 150


This will change the width of the first column in the MsFlexGrid.

For your second question:


Dim i As Integer

Load Form2
With MSFlexGrid1
For i = 0 To .Cols - 1
Form2.Text1(i).Text = .TextMatrix(.Row, i)
Next
End With
Form2.Show


Assuming tht Form2 has control array of Text1 (textboxes)

------------------

Serge

Programmer Analyst
sdymkov@microage.com
Access8484@aol.com
ICQ#: 51055819 (http://www.icq.com/51055819)

[mecca]

I'm not sure I understand how this snippet of code works...