Moving columns in forms

F

Frank

Probably an easy solution, but I haven't seemed to be able
to figure it out. I have a main form with a subform on
it. The subform is in datasheet view. I can adjust the
columns of the datasheet with no problem. Unfortunately,
I do not want it to do that. How to I freeze the
datasheet where columns cannot be adjusted.

Thanks,

Frank
 
K

Kevin Sprinkel

Hi, Frank.

Set the Allow Design Changes property on the Other Tab
to "Design View Only".

Kevin Sprinkel
 
G

Guest

Tried that and it still allows me to adjust the columns?
Anyone know why?

Thank you,

Frank
 
K

Kevin Sprinkel

Sorry, Frank; my mistake. I suggest you repost, though--
many MVP's only scan posts with no responses.

Best regards.
 
A

Anne

I don't think that can be done. I use continues form and make it look as
close as possible to datasheetview.
Anne
 
Top