Error troubles!

[Joe Holzhauer]

Hi!

I'm having trouble with a pesky bug. I'm trying to lock a text box with
VBA, but I keep getting error #2166: You can't lock a control while it has
unsaved changes.

The textbox is disabled on the form by default, so there can't possibly be
any unsaved changes (can there?). Does anyone have any ideas about this?

Thanks!
Joe

 

[Wayne Morgan]

Yes, if the control was changed through code.

 

[Joe Holzhauer]

I'm pretty sure I never touch it prior to trying to lock it. Is there a way
I can save any changes just to avoid the error?

Thanks!
Joe

 

[Graham Mandeno]

Hi Joe

Try Me.MyTextBox.Undo before modifying the Locked property.