Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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 data & 'Date with Color' text box changes color if date is not in future.

C:\fakepath\ColorChanging.odb

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.

C:\fakepath\ColorChanging.odbColorChanging.odb

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

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.

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.