Shading Rows in a Form

[djf]

I have a form in datasheet view. I would like to shade specific rows based on
the value of a certain field.

I have a field named Complete Date, if this field is not null I want the
entire row shaded in gray.

 

[dymondjack]

I'm pretty sure there's no options for editing field properties independantly
in datasheet view. Maybe in a continuous form that's formatted to resemble a
datasheet view though...

hth
--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill

 

[fredg]

I have a form in datasheet view. I would like to shade specific rows based on
the value of a certain field.

I have a field named Complete Date, if this field is not null I want the
entire row shaded in gray.

What version of Access? Access 2000 or newer?

Use Conditional Formatting on each control.

Select the [Complete Date] control.
Click on Format + Conditional Formatting
Set Condition1 to

Expression Is
Write:
[Complete Date] Is Null
as the expression.

Set the color.
Save the changes.
Then do the same for each of the other text controls in the record.

 

[ryguy7272]

This should give you what you want:
http://www.lebans.com/conditionalformatting.htm

This is good too:
http://www.lebans.com/alternatecolordetailsection.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

I have a form in datasheet view. I would like to shade specific rows based on
the value of a certain field.

I have a field named Complete Date, if this field is not null I want the
entire row shaded in gray.

What version of Access? Access 2000 or newer?

Use Conditional Formatting on each control.

Select the [Complete Date] control.
Click on Format + Conditional Formatting
Set Condition1 to

Expression Is
Write:
[Complete Date] Is Null
as the expression.

Set the color.
Save the changes.
Then do the same for each of the other text controls in the record.