Conditional Format Expression?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have a control named Billing with it's control source set to
BillingAddress
If the control is not null, then I need to change the color.
What would the correct syntax for this be, Please?
It is a text field.
 
1. Open your form in design view, and select BillingAddress.

2. Choose Conditional Formatting on the Format menu.

3. Set Condition 1 to:
Expression Is [BillingAddress] Is Not Null
 
I have a control named Billing with it's control source set to
BillingAddress
If the control is not null, then I need to change the color.
What would the correct syntax for this be, Please?
It is a text field.
Click to expand...

Using the control's Conditional Formatting (Access 2000 or newer):

Expression Is IsNull([Billing]) = True
 
I have a control named Billing with it's control source set to
BillingAddress
If the control is not null, then I need to change the color.
What would the correct syntax for this be, Please?
It is a text field.
Click to expand...

Using the control's Conditional Formatting (Access 2000 or newer):

Expression Is IsNull([Billing]) = True
Click to expand...

Whoops.
I just re-read your message and I see I reversed the logic.
It should be:
Expression Is IsNull([Billing]) = False
or
[Billing] Is Not Null
 
Same topic ... how would you add the dash in a conditional format for a ZIP
code? If the length is five, then the format is @@@@@, but if the length is
nine, then the format is @@@@@-@@@@. Can this be done with a conditional
format?

Best,
Christopher
 
Back
Top