Controls on Continuous Form - Conditional Formatting

[agouveia]

Hi Everyone,



I have an Access Continuous form in which I created some conditional formatting (some controls are locked upon loading and then unlocked depending on certain information being filled out). The conditional formatting works great when entering information into the form. Although, when exiting and then going back into the form, if you go back to that record, the controls that were unlocked are now locked and you would have to activate the conditional formatting again by choosing specific controls. I could always adjust data in the back end but I would rather the form not keep the conditional controls locked when going back into that specific record.

Thanks in advance for your help.

[isladogs]

Sorry but this is confusing to me.
Conditional formatting is used to change the appearance of various controls.
What has that got to do with locking controls?

Controls should be locked by using e.g. Me.MyControlName.Locked = True
If you have a large number to lock at once, the Tag property works well for that purpose

If you then want to change the appearance of those locked controls, that can also be done by e.g.

If Me.MyControName.Locked Then
Me.MyControlName.BackColor=vbCyan
Else
Me.MyControlName.BackColor=vbWhite
End If

etc....

[agouveia]

To clarify, some controls are already locked upon loading the form. Conditionally, these can be unlocked and if so, they can be used. Although, if exiting the form and then going back in to that record, the previously unlocked controls are locked yet again. I hope that makes sense.

[isladogs]

It makes sense but only because you haven't referred to conditional formatting (CF) this time!
So what's the problem again? Nothing to do with CF?
Perhaps some screen shots would help (if you can do that as a new user)

And, belatedly, welcome to the forum

[Missinglinq]

Your code for unlocking the Controls needs to be in the Form_Current event, as well as wherever else it resides (maybe in the AfterUpdate event of another Control) in order for the Locked/Unlocked status to remain Record specific, as you move from Record-to-Record.

Linq ;0)>