Using format conditions

[Roy Goldhammer]

Hello there

I have form that i need more then 3 format conditions

Is there a way to do this in access?

 

[Ron Weiner]

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

 

[Marshall Barton]

I have form that i need more then 3 format conditions

Is there a way to do this in access?

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.

 

[Roy Goldhammer]

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?

 

[Marshall Barton]

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?

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]