Prev: autoformat
Next: Control limitations
From: Mommybear on 24 May 2010 15:52
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.
From: Tom van Stiphout on 26 May 2010 22:19
On Mon, 24 May 2010 12:52:04 -0700, Mommybear
<Mommybear(a)discussions.microsoft.com> wrote:

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

-Tom.
Microsoft Access MVP


>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.
 | 
Pages: 1
Prev: autoformat
Next: Control limitations