By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

Conditional Formatting in datasheet view

100+
P: 121
Hi,

I have a sub form that i am applying conditional formatting to.

When a certain value is reached it turns the row red this all works fine apart from when i create a new record in the subform the pencil symbal appears next to the new record the next "pending" record that appears below that, with the asterix next to it, turns red also its only when you refresh the form it goes back to being white is there anyway of stopping the bottom row with the asterix turning red?

Thanks Phill
Feb 20 '09 #1
Share this Question
Share on Google+
4 Replies


missinglinq
Expert 2.5K+
P: 3,532
We really to see what conditions you're using for the Conditional Formatting in order to help you.

Linq ;0)>
Feb 20 '09 #2

100+
P: 121
The default formatting is set to the fill/back color is set to white

Expand|Select|Wrap|Line Numbers
  1. expression is [completedhours]>=[hourspercent]
if this is met then the fill/back color turns to red


Cheers Phill
Feb 20 '09 #3

missinglinq
Expert 2.5K+
P: 3,532
The problem, I suspect, is that when a new record is created [completedhours] and [hourspercent] are both Null, which means they are equal, and hence the Conditional Formatting kicks in. Replacing the formatting condition

Expand|Select|Wrap|Line Numbers
  1. [completedhours]>=[hourspercent]
with

Expand|Select|Wrap|Line Numbers
  1. Not ([NewRecord]) And [completedhours]>=[hourspercent]
  2.  
works when I ran up a test db.

Linq ;0)>
Feb 20 '09 #4

100+
P: 121
Hi Linq

Works a treat thanks


Phill
Feb 23 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.