Conditional Formatting Question

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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
 
Thanks Allen Brilliant.....Bob

Allen Browne said:
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.

Bob said:
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
Click to expand...
Click to expand...
 
Thanks Allen Brilliant.....Bob
Allen Browne said:
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.

Bob said:
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
Click to expand...
Click to expand...
 
Back
Top