Using format conditions

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

Roy Goldhammer

Hello there

I have form that i need more then 3 format conditions

Is there a way to do this in access?
 
Roy

I assume you are attempting to do conditional formatting in an Access Form.
To the best of my knowledge, three is it. You probably want to start
thinking about adding additional fields (and logic) to the record source of
this form (presumably a query) to reduce the number of conditions needed to
be considered by the conditional formatting.

Ron W
 
Roy said:
I have form that i need more then 3 format conditions

Is there a way to do this in access?
Click to expand...


Depends on what you mean by format conditions and how your
form is displayed.

You can use more that three conditions, but you can not
specify more than three (plus the default) formats. See the
Conditional Formatting examples at www.lebans.com

If your form is displayed as a single form (not continuous
or datasheet), then you can use code in the form's Current
event (and probably some control's AfterUpdate event) to
test as many conditions and set as many properties as you
want.
 
Thankes Marshell

But continues form is the form i need to use format contions

This form provide Shippment status on each shippment in the form
There are 6 statuses and each one of them must be paint in diffrent color

If this won't work it seems that i will have to use FlexGrid or DataGrid

Can you help me using DataGrid on access?
 
Roy said:
Thankes Marshell

But continues form is the form i need to use format contions

This form provide Shippment status on each shippment in the form
There are 6 statuses and each one of them must be paint in diffrent color

If this won't work it seems that i will have to use FlexGrid or DataGrid

Can you help me using DataGrid on access?
Click to expand...

No, I've never had a need for one of those grid thingies.

Another alternative is the way we used to do this kind of
thing back in A97. See these articles/examples:

http://www.mvps.org/access/forms/frm0024.htm

http://www.mvps.org/access/forms/frm0047.htm
http://www.mvps.org/access/forms/frm0055.htm

http://www.lebans.com/formatbycriteria.htm
--
Marsh
MVP [MS Access]


 
Back
Top