Search results

Well... it looks like its a flaw in Access when conditional formatting is used on a calculated field. My "Due Date" field is based on Date Raised +7 days. Found this on a website allenbrowne.com/bug-05.html Flaws in Microsoft Access Provided by Allen Browne, January 2004. Updated February...

Sorry to spam with messages, just figuring things out as I go. Just noticed that whenever this conditional format issue happens - the bottom left of the Access application main window shows "calculating..." like its stuck in some loop....

Here are some screenshots. There are actually two fields which have conditional formatting - "Due Date" and "Category"

By the way, I have tried repainting and requerying on load and on current and still no joy... :-(

Sorry I only just realised, its not in a subform, its in the detail section of the main form, just in datasheet view

Its on the subform in a datasheet view. The "due date" is a column

Hi All Firstly, Happy New Year to all! I wonder if you clever people could help a newbie like myself...? I have a database used for tracking tickets - and in one of my open ticket views (which is a form with a datasheet subform) I have set conditional formatting to highlight the due date...

Hi All Just thought I would say hi. New to the forums and pretty new to Access. I have had no training at all, but managed to successfully build two databases for the company I work for which are used daily and get rave reviews. I couldnt have done it wihout forums like this, and found that so...