Fred,
Thanks for the suggestions. This is a datasheet view that
the users use daily. They want the size to be permanent
once they adjust it, they don't want to resize it
manually every day, or every time they open it.
To think of it a different way, they want to be able to
magnify the zoom... which really sounds like something
that should go on an Access wish list!
Thanks again!
Karen
Karen,
Did you try it?
I gave you the how-to Karen.
You have to first make the changes.
When you exit the table, you will be prompted to save the changes.
If you save the changes, it will be that way when you re-open the
table.
Come to think about it, why are you having anyone look at, or work in,
the table any way. That's a good way to lose or mis-manage data.
Or did you mean a Form in datasheet view.
In Form Datasheet view it will work the same as table datasheet view,
except the changes are saved automatically without you're being
asked.... UNLESS someone has coded the column width and height to be a
particular size when opened, in which case you'll need to find and
change the code.
And what do you mean by " magnify the zoom"?
Form's have a Zoom Box, but not Tables.
You can open any particular control in Zoom Box by coding it's double
-click event, (DoCmd.RunCommand acCmdZoomBox) however it must be done
each time a control is accessed. I know that's not what you want.