Conditional formatting datasheets?

K

Kamil Dursun

I have a datasheet where I want to print some lines in read i.e. the lines where a deadline is earlier than today's date.

Thanks for any help
Kamil
 
A

Arvin Meyer

Kamil Dursun said:
I have a datasheet where I want to print some lines in read i.e. the lines
Click to expand...
where a deadline is earlier than today's date.

Conditional formatting does not include the ability to print lines. You can,
however, use it to change the background color of a cell or how the font
looks (color, bold, italic). In the form's design view, select the control
you want to affect then choose Conditional Formatting from the Format menu.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
K

Kamil Dursun

It is OK if I only paint a textbox red but I cannot find any property called "Conditional formatting" I was thinking to write some code to take care of this. Can you explain where I find the Conditional Format property?

Thx
Kamil
 
R

Rosco

Which version of Access are you using? I believe Conditional formatting was introduced in Access 2000 and later.

With your form in design view, select the control you wish to conditionally format.
In the format menu, select Conditional Formatting...

Hope this helps
Rosco
 
K

Kamil Dursun

I am using 2003. I have checked text boxes and combo boxes but I cannot find the property. Funny the help file says the same thing. Is there an option, an add-in etc. that I am missing?

Kamil
 
Top