Ask Your Question

Base, Query, conditional formatting [closed]

asked 2017-07-15 22:19:59 +0100

Joe Castor gravatar image

updated 2020-10-09 22:10:52 +0100

Alex Kemp gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Joe Castor
close date 2017-07-24 03:41:33.622634

2 Answers

Sort by » oldest newest most voted

answered 2017-07-15 23:26:05 +0100

Ratslinger gravatar image

updated 2017-07-16 07:43:15 +0100

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.

edit flag offensive delete link more

answered 2017-07-16 06:47:02 +0100

@Ratslinger, I get this error:

image description

edit flag offensive delete link more

Comments 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.

Ratslinger gravatar imageRatslinger ( 2017-07-16 07:45:51 +0100 )edit

@Ratslinger Thank you, it works now. gravatar ( 2017-07-16 08:10:45 +0100 )edit

Question Tools

1 follower


Asked: 2017-07-15 22:19:59 +0100

Seen: 171 times

Last updated: Oct 09