Columns in datsheet

[GeorgeDurkee]

How can I stop a user from moving the columns in the datasheet view?

I am creating a multiuser database and use both form and datasheet views for viewing data. In the datasheet view, the users are mving the columns around to meet their individual needs and when another leaves the application, they get a "Another user has changed the database" message, which freaks them out.

How can I stop a user from changing the layout of the datasheet?

Thanks [sig][/sig]

 

[Robertd]

Hi George,

ok for 97 you can "freeze" the columns you have to select each one rightclick on the column and select freeze, this locks the columns position. to unlock select menu->format-> unfreeze (all)

HTH [sig]<p>Robert Dwyer<br><a href=mailto:rdwyer@orion-online.com.au>rdwyer@orion-online.com.au</a><br>[/sig]

 

[GeorgeDurkee]

I tried this. What it does is lock a couple of columns on the left side of the screen and then keeps these from 'disappering' when you scroll left and right. This isn't quite what I need to do.

I need to lock 'ALL&quot; of the columns and keep the user from selecting the column, then moving it three columns left of where it started.

In additiom, if I use the 'freeze' feature on more than a window width of columns, I can't get to the right of the frozen area.

Thanks for the tip, but any other ideas?

George [sig][/sig]

 

[Robertd]

Hi George,

oh i see, ok i use continious forms for this as they are set at design time the down side is key navigation isn't the same as for datasheet but is ok for general use. maybe this could solve your problem. (you can set a from header up and put the field labels in the header) makes it look like a data sheet.

HTH [sig]<p>Robert Dwyer<br><a href=mailto:rdwyer@orion-online.com.au>rdwyer@orion-online.com.au</a><br>[/sig]