Conditional Formatting

[bellevue]

I have a form and want to use the Access 2000 built-in conditional formatting facility as I don't really understand VBA.

I have created a set of conditions (see below):



These all work fine; however, I work with Dutch and French as well and want to change the conditions to include the equivalent text in French or Dutch so that it recognises those languages as well as English. To explain what I mean, here's an example (for Condition 1) of what I'm trying to do:

[Accommodation]="Camping Pitch (Tent)" Or "Emplacement (Tente)" Or "Kampeerplaats (Tent)"

Will I be able to do this ?



Thanks

[Missinglinq]

The correct syntax would be

[Accommodation]= "Camping Pitch (Tent)" Or [Accommodation]= "Emplacement (Tente)" Or [Accommodation]= "Kampeerplaats (Tent)"

Linq ;0)>

[orange]

One thought that comes to mind is a change in design,
suppose you had a table of Accommodation Types and each type had an English, French, Dutch..... description or name

TypeId           EngDesc               FrenchDesc               DutchDesc
1        "Camping Pitch (Tent)" "Emplacement (Tente)" "Kampeerplaats (Tent)"

You could set this up with a langCd as well. This just for discussion.

This is quite common where multilanguages are involved. Of course it depends on how many of these values you have as to its applicability.
It does offer the ability to add more languages.

Just a thought for consideration. It does have implications on your design and existing code.

In your comparison you could check if accommodation.typeId =1

[bellevue]

Thank you so much "Missinglinq"; sometimes the obvious stares you in the face doesn't it !

Bless you

[bellevue]

Thanks also to "orange", a very interesting thought process...shall give that a ponder !