Locking Column Widths in Datasheet View

[Guest]

Is there a way to stop the user from changing the widths of columns in a
datasheet view?

I have some data on the form that I have set the columnhidden property to -1
so it is not readily available but a smart user might figure out that they
can grab the column and make it wider and accidentally find my hidden fields.
The data is not for the users eyes so it is rather important they don't do
this.

Any clues on how to lock a datasheet's column widths so no changes can be
made?

Thanks for any help.

 

[Stephen Lebans]

1) Michael Kaplan has an excellent article on manipulating Datasheets
here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart
01/html/sa01b1.asp


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.