Black list for a subform!

[haditirip]

Hello every body!
I want to create a black list for a subform
For example,when I enter a number to the subform,if the number be in blacklist,it become red color!
Please help me fast!!


thanks...

[June7]

What do you mean by 'in blacklist'? You have a table called 'Blacklist'?

Is the subform in Continuous or Datasheet view? Use textbox Conditional Formatting.

[haditirip]

Yes.It`s a table and for example thera are some phone numbers for blacklist
And subform is in Continuous

[June7]

Need to understand data structure and form design. What table do the numbers you select come from? Why is there a separate table for 'blacklist' numbers? Why would 'blacklist' numbers even be available for selection?

[Missinglinq]

To us Conditional Formatting, as you have to for this kind of Form, as Paul said, in Form Design View of the Form the Subform is based on:

1. Right Click on the Textbox to select it
2. Click on Conditional Formatting
3. Use the Condition1 dropdown to select Expression Is
4. In the box to the right type: DCount("*", "BlackListTable","PhoneNumber = '" & [PhoneNumber] & '"') > 0
5. You'll see B(old) I(talics) U(nderline) Paint Bucket (BackColor) A Big A ForeColor Enabled
6. Click on ForeColor or BackColor (whichever you want) and set the color as desired
7. Click on OK

This assumes that the phone number field is defined as Text. Even if a Field contains digits only, I define it as Text, not as a Number. I only use a Number Field if there's going to be math involved, but that's just a personal choice. If your Field is defined as a Number the DCount syntax would be

DCount("*", "BlackListTable","PhoneNumber = " & [PhoneNumber]) > 0

Linq ;0)>