How do I format a field based on the value

M

Mommybear

I have a form that is populated from a query using several tables. In the
detail section I have the following fields:

Category Code qty PO number ... .... ...

The qty is populated in the query based on whether or not a PO number is
available. If the PO number is not available then it comes from table a, if
it is available then it comes from table b.

On the form, I have my fields color-coded for easy reading. I would like to
be able to color the border and column heading based on where this value
comes from. If table A, then it is blue, if table b then it is red and
blocked from being updated (Locked = Yes).

Is this possible to do and if so How? If VBA coding is involved, please
spell it out for me as I'm still learning this. Thank you.
 
T

Tom van Stiphout

On Mon, 24 May 2010 12:52:04 -0700, Mommybear

No VBA required, just a look at "Conditional Formatting".

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
combo box value based on if - then statement 4
Open new record subform for data entry 11
updating table using user value 1
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Filtering based on data in another table 2
Need help on how to pass calculated field from a form to another form 0
Filter combo box in subform based on field in main form 1

Top