Record in a Datasheet

J

Josue R.

I have a datasheet form where the orders are displayed, from this list I
need to put on red color orders where daterequired for completion has
expired. I tried the following

If DateDiff("d", DateRequired, Date) >= 1 Then

DateRequired.BackColor = RGB(255, 0, 0)

Else
DateRequired.BackColor = RGB(255, 255, 255)

End If

This instruction works great with Form View, but as soon as I changed the
form to datasheet form the background doesn't change the color.

Any idea ?

Josue
 
S

Stephen Lebans

You will have to use Conditional Formatting.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change color of duplicate fields in a form 5
Run select query from VBA code where criteria comes from a multi select ListBox 2
conditional formatting vba code for a split/datasheet form? 2
Error 2101 2
How do add another code to a current one? 4
Changing Cells depending on data entered in other cells 1
Conditional Color Formating 1
QueryClose event of a form triggering Exit event of a textbox on that form 1

Top