D
Dennis
Hi,
I develop on XP Pro SP3 using XP Office Pro SP3. My user is running this
code on XP Home SP2 - Office 2007 Pro SP1
I have a form with a check box and a date field. The check box is a simple
true / false check box with no code behind it. If the chkBooster field is
checked, then the Booster Exp Date field should be enabled. If the
chkBooster field is NOT checked, then the Booster Exp Date field should be
disabled. The check box preceeds the the date field on the form.
Check box variables:
Fld Name = chkBooster
Control source = Booster (field on tbl)
Date field variables:
Fld Name = txtBooExpDt
Control Source = BoosterExpDt (field on tbl)
I have a conditional format on the date field. The condition format is:
Expression is Booster = False Enabled = False
This is the only condition on the field.
The above conditional format works on my XP PRO 2003 - SP 3 but does not
work on Office 2007 Pro SP1.
On 2007, I have to check the box, update the record, find my member again,
and then the date box will be enabled. If I check the box while in the form,
the date field will NOT be enabled.
If I put following code in the Form's Current and the the Check Box's After
Update Events:
If Booster = True Then
Me.txtBooExpDt.Enabled = True
Else
Me.txtBooExpDt.Enabled = False
End If
I can get the form to work correctly. I can leave the code there, but I
would like to know if I did something wrong in the conditional formatting.
I develop on XP Pro SP3 using XP Office Pro SP3. My user is running this
code on XP Home SP2 - Office 2007 Pro SP1
I have a form with a check box and a date field. The check box is a simple
true / false check box with no code behind it. If the chkBooster field is
checked, then the Booster Exp Date field should be enabled. If the
chkBooster field is NOT checked, then the Booster Exp Date field should be
disabled. The check box preceeds the the date field on the form.
Check box variables:
Fld Name = chkBooster
Control source = Booster (field on tbl)
Date field variables:
Fld Name = txtBooExpDt
Control Source = BoosterExpDt (field on tbl)
I have a conditional format on the date field. The condition format is:
Expression is Booster = False Enabled = False
This is the only condition on the field.
The above conditional format works on my XP PRO 2003 - SP 3 but does not
work on Office 2007 Pro SP1.
On 2007, I have to check the box, update the record, find my member again,
and then the date box will be enabled. If I check the box while in the form,
the date field will NOT be enabled.
If I put following code in the Form's Current and the the Check Box's After
Update Events:
If Booster = True Then
Me.txtBooExpDt.Enabled = True
Else
Me.txtBooExpDt.Enabled = False
End If
I can get the form to work correctly. I can leave the code there, but I
would like to know if I did something wrong in the conditional formatting.