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

Visual FoxPro1

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

Hi ,

You can try

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

If fourth coulmn is the above said pointer column.

Regards,

Markish

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

Hi Cetin,

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

Regards,

Markish

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

Yes I agree with you...