conditional formating

[swmorin]

Here is the issue I am having.

I have a continous form that displays different chapters students have to complete for different courses. So the forms list changes when you select a different course.

I.E.
Chapter 1
Chapter 2
Chapter 3

Now each chapter have different requirements to be considered finished. what I need is to know how can I make each record in the continous form check to see if there is any req for that chapter that is not met.

 

[vbaInet]

What are the requirements? What are the different conditions?

 

[swmorin]

The requirements will vary and can honestly be anything.

The condition will always be whether or not the cw_date has a value.

If it has a value the req is complied with.

The issue I am having is I am listing the chapters with a label that says completed or a label that says not completed. whether or not the label is visible depend on whether or not all requirements are met.

so each record in the main continous form would have to check to see if all requirements for that block have a value in the cw_date.

I figured i would use a query looking for all records for a chapter where cw_date = "".

And then have the not completed label visible if recordcount = 0. However I dont know how to make each record(chapter) do this.

 

[vbaInet]

You can't conditional hide labels in a Continuous form. Well, you can't apply Conditional Formatting on a Label control either. You can use a locked textbox to do this by using an IIF() function. To check whether it is a date use the IsDate() function.

 

[swmorin]

ok i got it to work mostly.

what I did wah use DCOUNT to count how many req where in each chapter, and then another DCOUNT to see how many that particular student had finished. I then used IIF statement to see if the number they have finished is less than then total number of requirements.

This works however when you load the form the it does not show up until you hover the mouse over the field.

 

[swmorin]

correction:
If I add conditional formatting you have to hover over it.

If I just set the =IIF statement as the control source you have to click on the field for it to show up

How do I get it to load automatically

 

[Rx_]

withdrawn - I missed it is a continous form - my suggestion would not work for sure. Thanks

 

[vbaInet]

@Rx: It's a Continuous Form, VBA code won't work. You can only use Conditional Formatting.

@swmorin: It depends on how you wrote the DCount() functions. Let's see them.