Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 10 of 10
  1. #1
    Guest
    Ok have a MS flexgrid, and one column can be either text or numeric. Currently text displays left justified and numerics right justified, how do l get the numerics to left justify.

    Have tried a string conversion to no avail....

  2.  

  3. #2
    Senior Member
    Join Date
    Apr 2002
    Location
    Cocooned in her thoughts
    Posts
    312
    Member #
    67
    Liked
    3 times
    this is something you do in excel to accomplish this : put a single quote before the number. I am not sure if that'll work here, however.
    Don't look so frightened
    This is just a passing phase

    One of my bad days...

  4. #3
    Senior Member
    Join Date
    Apr 2002
    Location
    Cocooned in her thoughts
    Posts
    312
    Member #
    67
    Liked
    3 times
    wot abt the following properties, did u try using them?

    .CellAlignment
    .ColAlignment
    .FormatString
    Don't look so frightened
    This is just a passing phase

    One of my bad days...

  5. #4
    Guest
    Thanks for the answers x man. Putting a ' before the data ain't an option, (in Excel you can set the column to text in format to fix the problem).

    Will have a look at .colAlignment and .cellAlignment


    Cheers,

    Will report back on results. Normally don't use MS grids cause they sux, but am forced to use standard MS controls....

  6. #5
    Guest
    Naturally vb doesn't bother telling me what values should go after the various properties

  7. #6
    Senior Member
    Join Date
    Apr 2002
    Location
    Cocooned in her thoughts
    Posts
    312
    Member #
    67
    Liked
    3 times
    J Boy J Boy!

    Press F2 in VB, go to the object browser...
    select MS Flexgrid in the upper left combo...
    select AlignmentSettings enumeration in the left pane....

    Or in the obj browser, search for AlignmentSettings
    Don't look so frightened
    This is just a passing phase

    One of my bad days...

  8. #7
    Guest
    Ok had a look at the horrible thing and had to use

    Code:
    flxContact.ColAlignment(1) = flexAlignLeftCenter

    That has to be the uglest code l have ever seen


    But it works...


    Cheers :thumbsup:

  9. #8
    Senior Member
    Join Date
    Apr 2002
    Location
    Cocooned in her thoughts
    Posts
    312
    Member #
    67
    Liked
    3 times
    why is it ugly?

    cheers anyways!
    Don't look so frightened
    This is just a passing phase

    One of my bad days...

  10. #9
    Guest
    The variable name for left alignment is just stoopid......

  11. #10
    Senior Member
    Join Date
    Apr 2002
    Location
    Cocooned in her thoughts
    Posts
    312
    Member #
    67
    Liked
    3 times
    heh heh .. true.
    Don't look so frightened
    This is just a passing phase

    One of my bad days...


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 08:54 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com