Search results

http://office.microsoft.com/en-us/templates/desktop-time-and-billing-TC010222096.aspx I downloaded the above template. It looks like it will do exactly what I need to do, which is record several employees' hours against several projects. What I don't need is the billing information such as...

I got it! I went back and deleted all the conditions, saved the db and took a break. When I came back I started over using your instructions and it worked like a charm. Thanks ever so much for your help and patience.

I went down the properties line by line and except for a gridline or two everything, including the conditional formula, is the same as for as I can tell. The only other thing I can think of is I used the autoformat in my big one when I set it up. Could that be it?

Ok. I've got the Lead row selected. I've got the back style set to normal. Back color set to #FFFFFF. Fore color is #373C43. I have my conditional formating to Expression Is [Lead] Is Null I'm not getting any red fill at any time now.

Thanks Sean. I went to the report in design view and right clicked on the text box. I see where it says "Transparent" and a color palette, I can't seem to figure out how to change it. Can you tell me how to do it please?

The one I uploaded is doing the same thing as my real one.

Maybe this will work

Sorry I haven't been back sooner, I had to go out of town. I am unable to upload the DB from work or home. I'll come back as soon as I figure out how to do it.

Will do. Thanks again.

I tried to upload a clean copy but I can't from where I am. I will try it over the weekend. Thanks for all your help.

I thought I might know what the problem is. I have two other conditions: One that between 1 and 31 May the font turns red. The other is between 1 and 30 Jun the font turns orange. The one I am doing now for the blank fields would be the 3rd condition. But it didn't make a difference. I...

You have yours doing exactly what I want to do, but when I use your formula on mine, it doesn't stick. The box turns red when I click on it in Report View, but goes back to red if I leave that box. It also won't print. I didn't do a form, just the table and the reports.

I have a link to another site that shows exactly what I'm trying to do, but it isn't working - the background doesn't stay red. I don't know if it's ok to post a link to another site here.

I wouldn't begin to know how to do that. I'm barely literate.

Thanks Sean. I just did, it didn't do anything.

Thanks for answering Sean, I should have said that first. I am doing the conditional formatting on the report in layout view. When I switch to report view and click the cursor in one of the formatted boxes is when it turns read. When I click on another box on the report, the red fill goes...

Basically what I would like to do is something like conditional formatting in the report where "Field value is" - "Equal to" - "Null" and the conditional formatting is red fill. I've tried that but it doesn't work. I know I'm doing something simple wrong, I can't figure out what it is.

No, it's a report. THe highlight works in layout view. I used a conditional format I found on here. "Expression is" - IsNull(Lead.Value) I don't remember where I saw the thread.

Access 2007. I have a report that includes the field Lead. It is in short date format in the table. I would like for a blank entry to fill the space on the report with a red fill. Not highlight, but stay red until a date is entered. I have read the instructions on how to highlight it, and...

New to the forum looking for help from time to time with Access. Thanks for all the great information.