I have been trying to create a "scratch" column in a local view that is of type memo. This column will be used as the control source for editbox controls in a grid. I can not seem to create a column using an expression such as replicate(" ",256) because that in gives me a zero length character field. The UseMemoSize has no effect.

Remote views seem to get around this problem by allowing you to change the column's datatype or setting the UseMemoSize property to an appropriately small size.

I am trying to use Local views to design my program for client server withought a server.

Here are some work-arounds I have found: please input.
1. In the data source for the view, there is a memo field that I would like to include in the view, so I use as the source field for two columns and I just make one of the columns updatable and I name the other column "scratch".
2. Use 255 characters which may be a suitable limit, but then I run into creating a 300k file for 1000 records!

TIA

Peter