I am using a datagridview as an input device and also as a means to display and edit previous input.

When using for the former, my error handler to test for a cell left blank works but when I use it for the display and subsequent edit, I get a run time error when I use If datagridview,rows(0).cells(0).value ="" then
end if

I believe that the error is caused by the fact that it has previously been loaded with an integer value so it will not accept the "" query as this is not an integer value.

I have got around this by establishing a string variable and setting the variable as the contents of the cell and then doing the test but I was just wondering if there was a way to reset the cell so that the contents were a string rather than an integer which it was initially when the data was loaded