Results 1 to 4 of 4

Controls on Continuous Form - Conditional Formatting

  1. #1
    agouveia is offline Novice
    Windows 10 Access 2007
    Join Date
    Nov 2018
    Posts
    2

    Controls on Continuous Form - Conditional Formatting

    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.

  2. #2
    ridders52's Avatar
    ridders52 is offline Voodoo Is Practised
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    2,471
    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.

    Code:
    If Me.MyControName.Locked Then
    
    Me.MyControlName.BackColor=vbCyan
    Else
    Me.MyControlName.BackColor=vbWhite
    End If
    etc....
    Colin (Mendip Data Systems), Website, email
    If this has helped, please click the star button and leave a comment

  3. #3
    agouveia is offline Novice
    Windows 10 Access 2007
    Join Date
    Nov 2018
    Posts
    2
    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.

  4. #4
    ridders52's Avatar
    ridders52 is offline Voodoo Is Practised
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    2,471
    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
    Colin (Mendip Data Systems), Website, email
    If this has helped, please click the star button and leave a comment

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 18
    Last Post: 04-11-2016, 02:23 PM
  2. Replies: 3
    Last Post: 08-02-2013, 11:18 AM
  3. Replies: 2
    Last Post: 12-22-2012, 06:49 AM
  4. Replies: 7
    Last Post: 10-01-2012, 06:59 AM
  5. Replies: 1
    Last Post: 06-22-2012, 02:33 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums