conditional formatting

[James G.]

Hi:

Right now I have had to build several databases that because of the
limitations of the conditional formatting have necessated the use of
seperating some data into several fields (i.e. Status and Sub-Status). I
have searched the internet and found something using VB code, which I do not
know how use. what I "REALLY" need is an add-in that "DOES NOT" need the
user to interface with code. Please help.

Thanks

 

[Brendan Reynolds]

Hi James,

As Mike says elsewhere in this thread, the user doesn't have to get involved
with code, only the developer does. But I think, in this case, when you said
user you meant you, the person developing the database. In that case, I'd
have to say that the conditional formatting feature was precisely
Microsoft's attempt to provide a way of doing this without using code. If
the feature doesn't meet your needs, then you'll need to use code.

If you have a specific question about the code you found, ask and we may be
able to help. If you need a more general introduction to getting started
with VBA in Access, I recommend the 'Beginning Access <version> VBA
Programming' series of books published by Wrox Press.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.