Results 1 to 3 of 3

Thread: Flexgrid

  1. Feb 19th, 2000, 11:28 PM #1
    gvirden
    gvirden is offline

    Thread Starter
    Member
    Join Date
    Dec 1999
    Location
    Greenville, MS, Washington
    Posts
    38

    Post

    How do you format time and date in flexgrid cells?
    Reply With Quote Reply With Quote
  2. Feb 20th, 2000, 03:04 AM #2
    Serge
    Serge is offline
    Serge's Avatar
    Join Date
    Feb 1999
    Location
    Scottsdale, Arizona, USA
    Posts
    2,744

    Post

    Like this. Assuming that the you want to format first column on the first row:

    Code:
    With MsFlexGrid
    .TextMatrix(0, 0) = Format(.TextMatrix(0, 0), "dd/mm/yy hh:mm AM")
End with

    ------------------

    Serge

    Senior Programmer Analyst
    [email protected]
    [email protected]
    ICQ#: 51055819
    Reply With Quote Reply With Quote
  3. Feb 20th, 2000, 03:30 AM #3
    gvirden
    gvirden is offline

    Thread Starter
    Member
    Join Date
    Dec 1999
    Location
    Greenville, MS, Washington
    Posts
    38

    Post

    Thanks Serge, that's great.

    Is there a property I could use to format the entire column without having to use loops?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width