Supress/hide similar values

[cfmiles]

Is there a way to supress one field if the value is similar to another field?

Example
Field / Value
Customer / Ocohee Park
Account Name / The Ocohee Park

In this case, I would want to show the value in the Customer field and hide the value in the Account name.

Example 2
Field / Value
Customer / Legends Raceway
Account Name / Raceway of South Carolina

In this case, I would want to show the values for both fields.

anyone?

Thanks in advance



[This message has been edited by cfmiles (edited 01-16-2002).]

 

[pcs]

based on the examples you gave:

you might try using the InStr function in the OnFormat event of your report and change the visible property of the 2nd control.

my suspicion, however, is that what you are trying to achieve, is probably more complicated than the examples given.


hth,
al

 

[KKilfoil]

Let me answer your question with another.

Can you define EXACTLY and COMPLETELY what you mean by 'similar values' in plain english such that any other person will ALWAYS choose to lump together any and all values as 'the same' in exactly the same way as every other person, given your 'rules'?

If the answer is 'NO', then there is no way to define what you are looking for in Access.

If the answer is 'YES', then tell us these 'rules' and we might be able to show you how to structure/code a solution.