This is where I am having trouble. When I set the visible property of the text1 texbox in a column to .F. in a command button on the form, I can only 'see' the change when that column has the focus.
That may be correct. I change it as I enter the cell since I only want to see the combobox if I want to edit that value. I have a code entry cell and when the value is entered, a method checks for a match and if not found allows a search on name in the combobox so the method has: if found() replace <txtDescription.value> (actually done in the view) THIS.grdItems.colDescription.cboDescription.VISIBLE = .F. THIS.grdItems.colDescription.txtDescription.VISIBLE = .T. else THIS.grdItems.colDescription.cboDescription.VISIBLE = .T. THIS.grdItems.colDescription.txtDescription.VISIBLE = .F. endif
The values for txtDescription are loaded in the view but are not part of the table so this is all I want to see unless I am editing a line.
I changed the Sparse property to .F. so that the entire column would show the change when the column got the focus I have Sparse .T.
I was more interested if you had found a way to address a particular cell of the grid (column as well as ROW). I'll look at that but I believe I did this with some other stuff I was playing around with. I'll let you know.
BTW are all the cells related to fields in the view - even if created with the view cf. exist in the table? for example is the calculated field created at the time of creation of the view?
©2001 graeme thomson |