Conditional Formatting (1 Viewer)

[muratas2]

Hello,

I have a continuous form containing two text boxes, txt1 & txt2. What I need to do is to disable txt2 in code depending on the values returned in txt1 i.e., let's say six records returned. For each record where txt1 less than 5, txt2.Enabled is to be set to False. I tried to do somthings but didn't work. How can I do it? Should I use another method other than Conditional Formatting?

Thanks a lot

Murat

 

[Travis]

If you are using a version of access previous to 2000 you will find conditional formating on a continuous form to be an uphill climb in rollerskates.

Otherwise with 2000 you can place this conditional formating code on the On Current Event and the AfterUpdate Event of the txt1 field.

 

[muratas2]

Hi Travis,

Thanks for your answer. But I couldn't see any code from you to be used on the events which you indicated. Appreciate if you can send send some sample code.

Thanks again

murat