How can I change the size of the columns in a datasheet?

[ayupchap]

Hi all,

I would love to be able to shrink the default size that the columns within my datasheets are appearing like. How do I do this and ensure they don't revert back to the default? I couldn't seem to find a place to do this.

Regards




Scott

[rpeare]

If you open the table in datasheet view, move the columns to the sizes you want then close the table you'll be prompted to confirm if you want to save the layout changes, just say yes and it should appear that way every time you open it

[ayupchap]

Oh this is great thanks so much!