Ask Your Question
0

Base, Query, conditional formating [closed]

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

Joe Castor gravatar image

updated 2017-07-15 22:21:14 +0100

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
0

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
2

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

@Ratslinger, I get this error:

image description

edit flag offensive delete link more

Comments

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

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

@Ratslinger Thank you, it works now.

charlie.it gravatar imagecharlie.it ( 2017-07-16 08:10:45 +0100 )edit

Question Tools

1 follower

Stats

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

Seen: 78 times

Last updated: Jul 16 '17