MSHFlexgrid.clip

G'day all,
Can anyone help with info on this function.
In particular what are the small boxes that seperate the cell content, and what code would I need to use to trap that.
IE
If mshflexgrid.clip = "box" then

This is one way to load data into the Flex Grid. (I refer to the MSFlexGrid control, the MSHFlexGrid is similar)

Basically you set up a string filled with data where the columns are separated by the tab character (Chr$(9) or the constant vbTab) and the rows are separated by the cursor return character (Chr$(13) or vbCR)

When you use this method of loading a flexgrid, you must create the required columns and rows and select them all <font color=red>before</font color=red> setting the .Clip property to your string.
Likewise the cllip property returns a string delimited by tabs and cr's for the selected cells in your flex grid.

A little hint, if you are going to build a string and load it, set the string to a large size first (using Space$ or String$) and then use the Mid$() function (Left hand side) to move through the data and set it rather than using concatenation, which is really slow...


HTH


<font color=blue>I once had an itch that I scratched and off fell my leg.</font color=blue>