MSFlexGrid Controlling

[Rajendra Nath Jana]

I generally using one TextBox control moving from Cell to Cell into the MSFlexGrid Control to access different data type values from user.
How can I use DTPicker Control, ComboBox Control, OptionButton, CheckBox Controls in several column into the MSFlexGrid Control.? or whether there is any grid control or third party utilities which will allow me to generate easer grid entry form which will support other controls attached with the columns?

[hariharanmca]

I generally using one TextBox control moving from Cell to Cell into the MSFlexGrid Control to access different data type values from user.
How can I use DTPicker Control, ComboBox Control, OptionButton, CheckBox Controls in several column into the MSFlexGrid Control.? or whether there is any grid control or third party utilities which will allow me to generate easer grid entry form which will support other controls attached with the columns?

For this you have to use control array. if you explain what is you requirement then we can give some other solutions.

[pureenhanoi]

I generally using one TextBox control moving from Cell to Cell into the MSFlexGrid Control to access different data type values from user.
How can I use DTPicker Control, ComboBox Control, OptionButton, CheckBox Controls in several column into the MSFlexGrid Control.? or whether there is any grid control or third party utilities which will allow me to generate easer grid entry form which will support other controls attached with the columns?

VideoSoft FlexGrid Control allow using checkbox, combobox, picture and text on cells. With dtpicker, maybe you must do manually by moving it from cell to cell. See www.videosoft.com for more details.

[Kabyr]

Hi,

I got this somewhere when i had same issue

Place the control on your form. Keep it somewhere it will not be visible at run time. say a combo box: Name is CboData. Your Flex Grid is MSFG

To place it in the grid...

add the following code to the click ecent of the FlexGrid:

CboData.Visible = False 'First hide the control

'Myy grid has 10 cols
If MSFGR.ColSel >= 2 And MSFGR.ColSel <= 9 ' cols 2 - 9 are cols i intend to edit.
'Resize the control to the grid cell size if neccesary
CboData.width = MSFGR.CellWidth 'Pick Cell width
CboData.Left = MSFGR.CellLeft + MSFGRoster.Left 'Position to Cell Left
CboData.Top = MSFGR.CellTop + MSFGRoster.Top 'Position to Top of Cell
'Take the curent value of cell and place in Cbo.text
CboData.Text = MSFGR.Text
Show the control
CboData.Visible = True
End If

when done, you can now place the value of the control into the cell
MSFG.text = cbodata.text ' You know where to get that from

It means the control will show only when you click on the cell.