• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

Change Backcolor of a text field in a continuos form or change the command button

I have a continues form and I need to change the color of the fields if the ONHD QTY > ORDER QTY.
How can i format the color depending on the criteria in Access 2003
0
tvae
Asked:
tvae
1 Solution
 
danishaniCommented:
Hi there,

Check below example out on how to achieve this;
http://www.databasedev.co.uk/conditional_formatting.html

HTH,
Daniel
0
 
Dale FyeCommented:
Use conditional formatting.  You can do one or both of the fields.

Open the form in design mode, select the control you want to format (or both).

The click the Conditonal Formatting button on the menu (don't recall precisely where this is in 2003).

Set the Condiwion1 dropdown to "Expression Is"

Then in the textbox to the right type:  [onhd qty] > [order qty]

did you really mean > or did you mean <

Then selec the desired background color and click OK.
0
 
tvaeAuthor Commented:
fyed,

Would that be the text box name onhnd or order qty or the field name in my query?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
tvaeAuthor Commented:
fyed,

disregard previous comment. I figured it out. Will this work the same as the command button or just fields?
0
 
Dale FyeCommented:
This only works for changing the background of bound controls, so it will not work for labels of command buttons.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

 Here's a sample DB which doesn't use conditional formatting, so your not limited to the types of controls you can use this width.

JimD.
ContinuousFormColors.zip
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now