Datasheet Column Widths

Is it possible to prevent the column widths on a subform, in datasheet view,
from being changed or to prevent any changes from being saved? The data in
the cells would still need to be available for modification.

????? me.datasheetcolumnwidth.enabled = false ?????

Thanks

To stop changes from being saved:You can force the form to not save changes

To stop changes from being saved:
You can force the form to not save changes when using docmd.close (see the
arguments for this action) or
you can use the access runtime where form changes will never be saved.

To stop changes from being allowed to happen I found this article:
http://www.dbforums.com/microsoft-access/1613454-lock-edit-column-size-datasheet-view.html

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com

If it is possible, it will likely be mentioned in MichKa's "You Can Do

If it is possible, it will likely be mentioned in MichKa's "You Can Do That
with Datasheets?" at
http://msdn.microsoft.com/en-us/library/aa217449(office.11).aspx

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

In addition to what has already posted, there is Stephen

In addition to what has already posted, there is Stephen Lebans'
AutoColumnWidth database, which contains a class module to freeze column
widths.

http://www.lebans.com/autocolumnwidth.htm

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

Indeed, that article discusses the very issue.

Indeed, that article discusses the very issue.

The interesting thing to me is that he does not talk about using the
events of the datasheet, which are just as powerful as for any form.
Certainly, there is nothing really different about datasheet events,
but I am surprised he did not mention it. The realization that a
datasheet was a form came to me only in the last couple of months
while working in the object browser -- as Michael mentions in the
article, if you look there you will see that a datasheet is an object
of type FORM.

--
David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/