Editing a flexgrid Philippe 12.07.2006 22:10:02 Hello, I would like to edit a MSHflexgrid in Access 2000, as I've done many times in VB6, using a floating Textbox. However in Access, my textbox always appears BEHIND the FlexGrid control, and so it is always hidden, even if I bring it to front in design view. And there is no Zorder method in Access as there is in VB. Is there a solution? -- Phil

Re: Editing a flexgrid "Warren" <warren_rapson[ at ]pacificnational.com.au> 13.07.2006 23:11:25 Hi Philippe, I would just like to add another question to your post, please forgive the backwards step. What is a flexigrid, and how does it work? What do the grid controls do? I'm hoping they allow data to be displayed in a html-style table on a report (if so, how?) Thanks Philippe, Warren

Re: Editing a flexgrid Philippe 14.07.2006 16:21:02 Hi Warren, A Flexgrid is an ActiveX object that you can include in a form. To use it, you must set a reference to "Microsoft Hierarchical MSHFlexgrid" in your project. It allows to display data in a tabular way, as you can see in Excel for example. It is very flexible to display tabular data. The problem is that a Flexgrid doesn't allow for editing the values in the table. To edit the value in a cell, you must superpose a "floating" TextBox on this cell, copy the data from the FlexGrid to the Textbox, edit the data, and then copy again from the TextBox to the FlexGrid cell. It works fine in VB6, but in Access, I cant manage to put the TextBox in front of the FlexGrid, it always appears behind and is hidden. -- Phil

Re: Editing a flexgrid mtermoul 29.09.2006 14:44:01 In my case I just wanted to put an image on top of the grid saying "Loading, please wait..." however I couldn't position the image on top of the flexgrid no matter what until I found out about the subforms. So to solve the issue I've put my image in a subform and put the subform on top of the flexgrid and it works, since Access is saying that subforms and list boxes will always be on top of other controls no matter what! I hope that this is helpful. "Philippe" wrote: [Quoted Text] > Hi Warren, > > A Flexgrid is an ActiveX object that you can include in a form. To use it, > you must set a reference to "Microsoft Hierarchical MSHFlexgrid" in your > project. > > It allows to display data in a tabular way, as you can see in Excel for > example. It is very flexible to display tabular data. > > The problem is that a Flexgrid doesn't allow for editing the values in the > table. To edit the value in a cell, you must superpose a "floating" TextBox > on this cell, copy the data from the FlexGrid to the Textbox, edit the data, > and then copy again from the TextBox to the FlexGrid cell. It works fine in > VB6, but in Access, I cant manage to put the TextBox in front of the > FlexGrid, it always appears behind and is hidden. > -- > Phil >