controllling text boxes with a text box 1

[kpryan]

Hi all,
I have a text box that when it has a certain text in it that other text boxes will change background.

I did try this, but not very successful

If textbox 1 = "paid" then
textbox2.background = 256 ( or other colour)
else
textbox2.background = 0

end if.

How can I get this to work.

Many thanks,

KP

 

[Remou]

Are you using a continuous form or a single form? What event did you use?

 

[kpryan]

Hi Remou
Its a continuous form and I put this on the 'on load event'. So that when the form is opened it will show certain records.

many thanks,

Kp

 

[Remou]

You need to use Conditional Formatting for a continuous form.

 

[kpryan]

Hi Remou,
Yes I have tried conditional formatting, but not sure how to write the code.
If I was to use a checkbox then I could write eg:
[chk] = true and then apply a background colour.

But how do I use a text box set with a certain text, ie "paid" to use the same color background.

KP

 

[Remou]

Conditional formatting is an item on the menu (design view). Is that where you are looking?

 

[kpryan]

Hi remou,
Yes I know where the conditional formating is. But I dont know how to write the expression to get it to work.

Many thanks,

KP

 

[Remou]

You can use:

Expression Is [TextBox1]="Paid