Which form event triggers a procedure ....

[Helmut]

Here's the problem....
I have a table which I want to develop into a form. in this table (and on
the form) is a data element which can contain a value of 50-54. I want to
test this value and depending on the value, change the background color for
that data element for each row in the table.

Which event on the forms properties list will trigger this code?

Thanks in advance,

Helmut.

 

[Alex Dybenko]

Hi,
I think you can try Conditional Formatting. Open form in design view, select
textbox and go to menu Format-Conditional Formatting (or find one on the
ribbon)

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Helmut]

Alex;
Conditional Formatting only limits you to three values I believe. I have
five. Do you know of any way that the Conditional Formatting limitation can
be expanded or have an alternative method?

Thanks
Helmut

 

[Dirk Goldgar]

Conditional Formatting only limits you to three values I believe.

Well, technically 4, since the default case has to be included as a
"formatting".

I have
five. Do you know of any way that the Conditional Formatting limitation
can
be expanded or have an alternative method?

Conditional formatting's limitation of 3 conditions per object can be hard
to get around. This question came up recently in another thread, and I
posted this (rather cumbersome) workaround, which may possible be useful to
you:

http://groups.google.com/group/microsoft.public.access/msg/0c762dfbf998e669

It takes more time to set up, but it works (for background colors), and
doesn't even use CF.

 

[Helmut]

Thank you. I'll give it a try.
Helmut.

Well, technically 4, since the default case has to be included as a
"formatting".


Conditional formatting's limitation of 3 conditions per object can be hard
to get around. This question came up recently in another thread, and I
posted this (rather cumbersome) workaround, which may possible be useful to
you:

http://groups.google.com/group/microsoft.public.access/msg/0c762dfbf998e669

It takes more time to set up, but it works (for background colors), and
doesn't even use CF.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)