How to Protect Memo Fields in Forms...YIKES!

[Randix]

I have a form that has lots of memo fields, I want to make it read only...the snapshot view doesn't protect the memo fields, nor does turning off the edit, add, options as properties in the form...any suggestions how to allow viewer to see them, expand them, etc., but not modify??????

 

[Rich]

Just set the data tab Locked to yes enabled to no.

 

[Randix]

Rich...my form has something like 30 memo fields...i really don't want to have to go into each field to make that setting (I have 6 other forms just like it), i was wanting to do something to the form property itself but nothing seems to have any impact on those darn memo fields...

 

[Randix]

Ok, solved the problem by putting the Me.Undo command in the beforeupdate field, preceded by a message telling the user changes are not allowed...

 

[Atomic Shrimp]

In the form design view, you can amend the properties of multiple objects all at once, by holding down <Shift> and selecting them one at a time until you have selected them all; the properties box will display any properties that all of the selected items have in common, so you could quite quickly and easily (I would think) set the Enabled and Locked properties.

[This message has been edited by Mike Gurman (edited 03-29-2001).]

 

[Randix]

Mike...thanks for the tip!