Conditional Format Hyperlinks

[esipp]

Because they are more efficient, I am using hyperlinks to connect my forms. I want to be able to deactivate hyperlinks based on criteria that are selected.

Please help!

 

[Ukraine82]

I'm not sure if you deativate the hyperlink, but ever thought about locking the hyperlink field if it doesn't match your criteria.

hth,
Michael

 

[esipp]

How do I lock the hyperlink field? (Sorry, I'm a newbie)

 

[Ukraine82]

How do I lock the hyperlink field? (Sorry, I'm a newbie)

I'm not sure what your criteria is. Here is an example let say you want your field2 to be locked only if your field1 is blank.

Lock Field2 by going to property and set Enabled = No

In the After Update event of the field1:

If Not IsNull([Field1]) Then
Me.Field2.Enabled=True
End If

hth,
Michael