By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,041 Members | 1,734 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,041 IT Pros & Developers. It's quick & easy.

Conditional formatting help please

P: n/a
Hello,

I have the following in a form:
[StatusDropDownBox]
22 In collection
23 External to collection
24 Deceased
25 Sold
[SoldTo]
[DateSold]
I would like the SoldTo and DateSold field to be disabled (or even
invisible) and saved with a null value if StatusDropDown has a value of 22,
23, or 24. The Null value needs to be forced and saved in both fields
whenever the value of the dropdown box is 22, 23, 24.

Thanks a lot!!

Tim G.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Tim

To do that, you need to create an AfterUpdate Event linked to the
StatusDropBox where you would include the following code:

If me.statusDropDownBox = 22 or me.statusDropDownBox = 23 or
me.statusDropDownBox = 24 Then
me.SoldTo = Null
me.DateSold = null
me.SoldTo.Visible = False
me.DateSold.Visible = False
Else

me.SoldTo.Visible = True
me.DateSold.Visible = True
End if

HTH

Chris

"Tim Graichen" <Tg*******@neo.rr.com> wrote in message
news:cy*******************@twister.neo.rr.com...
Hello,

I have the following in a form:
[StatusDropDownBox]
22 In collection
23 External to collection
24 Deceased
25 Sold
[SoldTo]
[DateSold]
I would like the SoldTo and DateSold field to be disabled (or even
invisible) and saved with a null value if StatusDropDown has a value of 22, 23, or 24. The Null value needs to be forced and saved in both fields
whenever the value of the dropdown box is 22, 23, 24.

Thanks a lot!!

Tim G.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.