Conditional Formatting in a Continuous Form in Access 2007

[jdashm]

I have a continuous form in which I need 3 fields to be disabled based on a user clicking in a checkbox (marking it to True).


I have created some VBA to deal with that but it seems to disable those fields in all the records instead of just the current one.
I have also tried some Conditional Formatting to disable these fields but it does not seem to work. Is this a condition of continuous forms?
Here is the vba that I have currently have...
==================================================
Private Sub ysnShipReady_AfterUpdate()
' Enables or Disables Drivers Name, No. of Pkgs, Pickup Time fields if chkShipReady checkbox is on/off



If Me.ysnShipReady = True Then


Me.strDriverName.Enabled = False
Me.bytNoPkgs.Enabled = False
Me.dtmPickUpTime.Enabled = False



Else
Me.strDriverName.Enabled = True
Me.bytNoPkgs.Enabled = True
Me.dtmPickUpTime.Enabled = True


End If


End Sub
=========================================
Thanks in advance for the help.

[Micron]

Access does not distinguish between a control on one record versus another when it comes to continuous forms, and this includes conditional formatting.

[pbaldy]

I'm going to disagree. Conditional Formatting will format controls in different records differently based on the condition. That's its purpose in life. As long as your controls are textboxes, you should be able to disable them conditionally. You'd use Expression Is (or whatever it may be called in 2013), and an expression like:

[ysnShipReady] = True

[CJ_London]

I agree with both Micron and Paul

OP is not using conditional formatting in his code - so Micron is right so far the code is concerned

Paul is right about conditional formatting

OP - see this link about applying conditional formatting - no vba required

https://support.office.com/en-us/art...ad=US&fromAR=1

[pbaldy]

I interpreted, perhaps wrongly, that the capitalized words Conditional Formatting meant the OP had tried the non-VBA "on the ribbon" approach and failed:

"I have also tried some Conditional Formatting to disable these fields but it does not seem to work"

[jdashm]

Yes I meant the Conditional Formatting command on the Design Tab ribbon.

[jdashm]

If both my VBA and Conditional Formatting are working...
the VBA is disabling those fields in every record in the continuous forms...
the Conditional Formatting command just doesn't seem to work at all.
I am using the criteria you mentioned ([ysnShipReady] = True).
Any ideas about how I can get this to work.

Thanks.

[pbaldy]

The VBA won't work. The ribbon option should. Can you attach the db here?

[Micron]

I'm going to disagree. Conditional Formatting will format controls in different records differently based on the condition. That's its purpose in life. As long as your controls are textboxes, you should be able to disable them conditionally. You'd use Expression Is (or whatever it may be called in 2013), and an expression like:

[ysnShipReady] = True

Access does not distinguish between a control on one record versus another...
I think you misinterpreted my intent (and maybe I didn't express it very well either). I meant you cannot apply a conditional format to a control and expect it only applies to a single record. It applies to all.

[pbaldy]

I'll agree if you mean with VBA code.

[Micron]

If you can assign a conditional format to any field and it only works on one record (and not any other record with the same value) I'd truly like to learn how to do that, regardless of how it's done.

[pbaldy]

It can be done with Conditional Formatting, on the ribbon. See the link Ajax posted above. I've used it many times.

[pbaldy]

Oh wait, you said "not any other record with the same value"? You'd have to include a reference to that record or something. Maybe I've misunderstood what you've been saying. I'm hip deep in a SQL Server problem.

[Micron]

I can tell you with 99.5% assurance that it cannot be done. I've tried to solve this issue in several ways with underlying controls and other tricks. Whatever you do to one control applies to all of the records for that control.

[pbaldy]

Can you clarify the specifics or post a sample db? I respect your knowledge so I'm not disagreeing with you, but I don't think I'm understanding your situation. You can certainly conditionally format a form such that some records are affected and others not, based on your condition.