Fixed column widths in SubForm

[nyteowl]

I've got a SubForm with 9 columns. Default View is Datasheet and all values for allowing other views are set to No. Can Grow and Can Shrink values for the sub-form and every object on it are set to No. Everything looks great, but when I open the Main Form in View mode, I can still go into the SubForm and adjust the column widths, which is exactly what I don't want to happen.



I'm obviously missing something somewhere, but I can't find any more sizing-related parameters to disallow. What else should I be looking at?

[pbaldy]

Personally, I'm not a fan of datasheet view, for this and other reasons. I'd try continuous view, and you should be able to achieve a similar look.

[nyteowl]

Well, that certainly did the trick...

Thanks again!!

[pbaldy]

No problemo! I think you'll be happier in the long run. You have a lot more control with continuous view.

[nyteowl]

I really appreciate the assistance. I used to know a lot of this stuff, but have been away from Access for a number of years. Now I'm surrounded by folks who use spreadsheets for everything, so I'm working up a few small databases to make my life easier.

Have a great weekend!!