conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
James said:
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.
Click to expand...
The user does not have to be involved at all.

Once you get past what Access offers built in, the programmer has the task
of writing the conditional coding.
With the exception of continuous forms this is usually not a problem and
requires only an IF statement if simple or a case statement if you need a
lot of choices.
 
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.
 
Back
Top