mshflexgrid (VB6)

Topic

New Reply

Can anyone point me to a good reference on the mshflecgrid? I am specificaly trying to format a column with a number format.

thanks,

Reply | Quote

Replies

What does your SHAPE statement look like? I haven’t found a good reference on the critter, but I’ve managed to use them a few times. If the statement is at all complicated, you might want to rethink the way you’re populating your grid.

Reply | Quote

Sorry, I don’t have access to flex grid just at the moment.

There is help available on the MS site, as well as the online help. It takes a bit of digging though if you don’t know exactly what you’re after.

My immediate thought would be to use a format statement to format a number into a string, and then populate the grid element with the formatted string.

Reply | Quote

I’ve now looked up my coding of the mshFlexGrid. The way I’ve populated rows in the grid (rightly or wrongly) is in the form:

msFlesgrid1.AddItem strItem & vbTab & format(datDate, "dd/mm/yyyy") & vbTab & ...

where vbTAB separates one column from the next

Reply | Quote

Geoff,

Were you working with the FlexGrid or the hierarchical flexgrid?

Reply | Quote

I was working with mshflexgrid. The reference was still to msflexgrid1 (excluding my previous typo).

Does that make a difference? I don’t know a lot about the difference between the two.

Reply | Quote

Well, with the hierarchical version, you can create a shaped recordset using the MSDataShape provider and set the flexgrid’s recordset property to that rather than adding to it the way your code did. I’ve always done it that way, so I’m not familiar with the method you suggested.

Reply | Quote