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 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-ac...heet-view.html

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


"Confused Slug" wrote in message
...
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

If it's possible, it'll likely be mentioned in MichKa's "You Can Do That
with Datasheets?" at
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

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


"Confused Slug" wrote in message
...
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

"Confused Slug" wrote in message
...
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.


In addition to what has already posted, there's 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)

"Douglas J. Steele" wrote in
:

If it's possible, it'll likely be mentioned in MichKa's "You Can
Do That with Datasheets?" at
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Indeed, that article discusses the very issue.

The interesting thing to me is that he doesn't talk about using the
events of the datasheet, which are just as powerful as for any form.
Certainly, there's nothing really different about datasheet events,
but I'm surprised he didn't 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'll 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/