conditional formatting to one unbound text box with multiple controls

[RSTaylor]

I have a form that is utilized for inputting Emergency Medical Service patient care reports. What I'm looking for is the ability to put an unbound text box on the form, and based on whether all fields are filled in or not, it would display "Incomplete" with a red background or "Complete" with a green one. I've been told I could use conditional formatting to set this but how would I go about selecting all fields for this conditional formatting on this one unbound textbox?

 

[dhookom]

You could try a control source like:

=Nz(FldA+FldB+FldC...+FldZ,"Incomplete")

then set the conditional formatting of each control based on this one.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

Howdy dhookom . . .

Nice Idea!

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[RSTaylor]

Forgive me, but I can't seem to make that work. I keep getting the following error: "The expression you entered contains invalid syntax. You may have entered a comma without a preceding value or identifier.

 

[dhookom]

RSTaylor,
We are having trouble seeing "The expression you entered". I'm not sure how you can expect us to fix something we can't see.

Duane
Hook'D on Access
MS Access MVP

 

[RSTaylor]

The code I used was from dhookom

=Nz(FldA+FldB+FldC...+FldZ,"Incomplete")

 

[dhookom]

Did you try to substitute your actual field names for "FldA+FldB+FldC...+FldZ"?

Duane
Hook'D on Access
MS Access MVP

 

[RSTaylor]

Yes, I put in field PatientName, MRN, CSN, HAR, DPT, AST, IST, etc...

 

[dhookom]

We are having trouble seeing "The expression you entered". You are providing a little more information than before but you haven't given us the actual expression. Also, what's the name of the control?


Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

RSTaylor . . .

Post the code [blue]exactly as you have![/blue] Its a simple copy & paste.

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]