Changing a text box conditionally

[hilbertm]

First I am a beginner, but I am trying to learn VBA. I have a form that has a text box that contains the sum of records generated in a query. My question is: can I change the background color of the text box when the number is higher than 0. I would like the background to change to red when the number in that text box is greater than 0.
Thanks in advance for any help.

 

[Rich]

In A2K look up help on conditional formatting.
HTH

 

[hilbertm]

Sorry I did not say I am using acess 97 right now.

 

[Rich]

Continuous form which type? Currency or number?

[This message has been edited by Rich (edited 09-18-2001).]

 

[hilbertm]

I'm not sure what you mean by continiuous form and the type of form. The number is just a number with no decimal point. I have a form that opens when the database is open. I use the following in the control source for the textbox
=DCount("*","INITIAL REVIEW not complete LIST")
to get the number of records that meet the query. Right now the number of records that meet the conditions of the query are stated in the text box. I would like the background to change to red when there is a change from 0.