Field Size

Hi Kate

Thanks for your questions.

I would not expect any reduction in size. While access presets the field size for numeric and date data, it only uses sufficient memory to store what is entered in a text field.

It is however puzzling that the size increased, and your memory issues suggest that the file is too large for the memory on your PC

I suggest trying to compact and repair the database.

First back up the database. This is important, because if the database is too large for the memory this process could crash resulting in damage to the data.

This done, go to Tools - Database Utilities /-Compact Database to compact the database.

This might reduce the file size.

Regards

Stephen