How do I lock Subform DataSheet Columns (access97)

[Luther1978]

G'day All, I'm building a datbase to be roled out to multiple users. On many of the forms I am displaying information in a subform as a datasheet. When I enter information onto these forms I can't help but occasionally adjust the sizes of the columns in my subforms. Does anyone know of a way to stop this? If I'm having a problem with it the users cetainly will.

Many Thanks in Advance

Martin King

 

[Crowley16]

I'm not too sure just what controls are available with datasheets...
I tend to use a listBox as a datasheet, it supports everything a datasheet does, puls it has controls for col width, record selected and a host of other stuff...

 

[Luther1978]

Thanks Crowley, have never thought of using a listbox for this purpose before.

There seems to 2 limitations at 1st glance.

The first is filteringthe information in the listbox to show only those related to the parent form. Although this shouldn't be too hard to rectify with a little thought.

The other is that my subforms contain true/false fields that show nicely as a tick box, the list box seems to show them as -1/0.