Using OnCurrent to Conditionally Lock Records

D

dch3

You know it'd be nice if the FormatConditions object exposed the .Locked
property...but it doesn't.

I need to highlight a comboBox a specific color AND restrict changes to its
value. Using the FormatConditions object, I can obviously set the .Enabled
property to False, however this overrides any .ForeColor and .BackColor set.
So I was thinking about setting the .Locked property via the OnCurrent event
of the form. Since its data-related and not format-related, the users
shouldn't see anything.

Any ideas or feedback?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Format Conditions? 1
Conditional Formatting Problem 0
Record Locking 2
Highlight current record 8
Border goes Solid on Conditional Format 0
Lebans Code 0
Annoying OLE locked message 0
Inconsistent Conditional Format Copying 0

Top