Conditional Formatting Question

[Bob]

If there is no data in a text box I want it to turn red, what code would I
use!
Thanks in advance.........Bob Vance

 

[Allen Browne]

Assuming Access 2000 or later, you can do it without code:

1. Open the form in design view.

2. Select the text box that will go red.
(We will assume it is named Text0 for this example.)

3. Choose Conditional Formatting on the Format menu.

4. Set Condition 1 to:
Expression [Text0] Is Null

 

[Bob]

Thanks Allen Brilliant.....Bob

Assuming Access 2000 or later, you can do it without code:

1. Open the form in design view.

2. Select the text box that will go red.
(We will assume it is named Text0 for this example.)

3. Choose Conditional Formatting on the Format menu.

4. Set Condition 1 to:
Expression [Text0] Is Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

If there is no data in a text box I want it to turn red, what code would
I use!
Thanks in advance.........Bob Vance

 

[Bob]

Thanks Allen Brilliant.....Bob

Assuming Access 2000 or later, you can do it without code:

1. Open the form in design view.

2. Select the text box that will go red.
(We will assume it is named Text0 for this example.)

3. Choose Conditional Formatting on the Format menu.

4. Set Condition 1 to:
Expression [Text0] Is Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

If there is no data in a text box I want it to turn red, what code would
I use!
Thanks in advance.........Bob Vance