Column Visible in Grid

Ok, I am creating a grid and I need to create a column called "ProvRecno" to use for a refrence pointer. I can make the column, and I can see all the info I need, however I want that column to be non-visible. I am not sure how to set this column to visible = .f.

The Grid is built from a SQL select, and I need some way to select the column titled ProvRecno so that I can set its visibility to .f.

Any Ideas



Answer this question

Column Visible in Grid

  • bmains

    Hi Cetin,

    Can we set the columns' width property to zero in case of older versions....

    Regards,

    Markish



  • pinoyz

    Yes I agree with you...

  • xw

    Probably he is asking for his version is old and doesn't support visible = .f. behavior as it does under VFP9 (wish posters always added the version number they're using). In older versions (ie: 7) end result was:

    Column is still there and visible. Only content is 'empty'.


  • Nicolás C.

    Then in your select put that column in last position and in your grid set columncount to be less than field count.
  • averge joe

    No setting to 0 was also ill behaving. It was setting to columnwidth to 0 but gridline is there, making a thicker gridline (the more the invisible columns the thicker the line was). And using tab key or alike that column(s) is visited in between (user gets confused where the cursor is when that column gets focus).
  • swalker

    Hi ,

    You can try

    Thisform.mygrid.columns(4).visible=.f.

    If fourth coulmn is the above said pointer column.

    Regards,

    Markish



  • Column Visible in Grid