Shading Rows in a Form

  • Thread starter Thread starter djf
  • Start date Start date
D

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.
 
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
 
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.
Click to expand...

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.
 
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''.


fredg said:
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.
Click to expand...

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.
Click to expand...
 
Back
Top