Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mshflexgrid (VB6)

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

    thanks,

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: mshflexgrid (VB6)

    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.
    Charlotte

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mshflexgrid (VB6)

    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.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mshflexgrid (VB6)

    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:
    <pre>msFlesgrid1.AddItem strItem & vbTab & format(datDate, "dd/mm/yyyy") & vbTab & ...</pre>


    where vbTAB separates one column from the next
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: mshflexgrid (VB6)

    Geoff,

    Were you working with the FlexGrid or the hierarchical flexgrid?
    Charlotte

  6. #6
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mshflexgrid (VB6)

    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.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: mshflexgrid (VB6)

    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. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •