Conditional Formatting

I have been playing with conditional formatting, but can't get what I want.
I need a text box to have a yellow background color when it is empty, and get the normal white background color when something is put in it. This also means that, if the text is being deleted, it has to go back to yellow.
Can anyone help me? Thanks. Trucktime

Try this

If IsNull(TextBox) or TextBox="" Then
TextBox.BackColor = 8454143
Else
TextBox.BackColore = 16777215
End If

lwells

I got it to work.
Thanks IWells. Trucktime

i don't know if i a new thread is called for, so i'll just piggy-back my problem description onto this one and hope for the best....

i am using a2k.

to make things simple, let's say i have a combobox (cbx) on my form as a bound control to an underlying table. the control source and name of the control is 'Cycle'. it's defined as a 'byte' number on the table's design and gets filled in by the user from a l/u table having the values 1,2,3,4,....28,99 (there are no numbers btwn 28 and 99 on purpose).

what i'm trying to do is cause this field to have a red background when the user is creating a new record to draw user's attention to fact it needs to be entered (it is the second member of a composite PK comprising "Patient Number" and "Cycle"). so, i want the background to display in red until the user's entered a value from the l/u table.

what i've done is decreed the field's default color is red and in the conditional formatting pull down thing used an "Expression is" option for Condition 1 that says "[Cycle] Is Not Null" (w/o the quotation marks).

it's weird, but the field color is never red for this cbx control when the field is open i add record mode although it is red in the design mode. however there is a neighboring control alongside it called "Day Number" which has the said configuration which complies with my design?!?

any clues?