I have searched and can't find a way to do conditional formatting (color a cell based on a condition; e.g. date 1 < date 2. Does this exist at the Query/View level? Thank you Joe Castor
Changing control properties based upon conditions is only done through macro coding. For a rough example a sample is attached. Group box changes color depending upon COLOR1 (only 'blue', 'green', 'yellow' & 'red' are coded) data & 'Date with Color' text box changes color if date is not in future.
ColorChanging.odb - corrected version
EDIT: In re-reading your question, no there is no way to format a query result set. The same is true of a table view. Sorry for mis-reading your question.
@Ratslinger, I get this error:
@charlie.it Thank you. Those are the lines I seem to miss when posting. Sample in answer is now corrected. I believe you understand you can just delete that line and all will run OK.
Asked: 2017-07-15 22:19:59 +0100
Seen: 224 times
Last updated: Oct 09 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
