Datasheet layout will not save

[Steve C, MFS]

Hi. This is a bit of a silly one, but it is doing my head in! I am
developing a complex database and there is lots of interaction between tables
which means it is often convenient to have multiple tables open
simultaneously. However, I do not seem to be able to save the datasheet view
layout. I have clicked the save button (floppy icon) and tried File->Save
but neither work. Next time I open the table it is back to its original
large window and default column sizes.

Anyone know a way around this, so I can save layouts rather than having to
drag corners and columns every time I open the table?

Thanks,

Steve C

 

[Íõ»¢]

ÄãÃǺÃ

 

[John Spencer MVP]

Nope, there is no way to save the datasheet layout of a table.

Perhaps you can use a query in datasheet view - you can save most of the
layout changes for queries. You can set the query to show all fields.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County