freeze colum width on subform

[pdtit]

Hello,

I wonder if it is possible to "freeze" the columns I use in a subform.

I want to block the user on modifying the used width of each column, to make sure all supposed columns are always on screen, and not moved by some end user.

Regards

Peter

 

[PHV]

Have you tried to play with the AllowDesignChanges property of the Form object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya pdtit . . .

I could be wrong but it sounds like your [blue]subform view is set to DataSheet[/blue]. If this so switch to [blue]Continuous[/blue] view and all fields will be locked to design settings.

[purple]You can make continuous view look just like a datasheet![/purple]

See Ya! . . . . . .