Background of individual records

[Guest]

I have a form with diaries each diairy is a record and each record has a
combo box that pulls from a table with three records indicating whethor or
not the diary entry is critical or a daily task. If the diary is a dialy
task I need to set the background color of the diary to red and blue if it is
just a daily task does anyone know how to perform this.

 

[Guest]

If you are using a continuous form then use conditional formating
(Format/Conditional Formating). For a single form you can use the onCurrent
event to change a control's color. If whatever then Me.controlname.BackColor
= vbRed Else Me.controlname.BackColor = vbBlue

 

[John W. Vinson]

I have a form with diaries each diairy is a record and each record has a
combo box that pulls from a table with three records indicating whethor or
not the diary entry is critical or a daily task. If the diary is a dialy
task I need to set the background color of the diary to red and blue if it is
just a daily task does anyone know how to perform this.

If you have A2002 or later (maybe 2000, I don't recall) you can use
Conditional Formatting to do this. Select the control or controls you want
colored; on the menu select Format... Conditional Formatting. Follow the
instructions on the screen.

John W. Vinson [MVP]