Conditional Formatting: Expressions

  • Thread starter Thread starter elwood00
  • Start date Start date
E

elwood00

I have a form, where I'd like to have the field 'List Link' only enabled
when the checkmark for the field 'Link' is set - or if the value of
'Link' <>0.



I must be doing something wrong, since the field stays 'disabled'
regardless of the value of 'Link'



My expression is: [Link]<>0 - I alos tried "0" and '0' - all to no
avail.



Also the =-1 - "-1", '-1' attempt did not produce the desired results.



I even double checked by saving and closing the form after setting the
value to -1 - then I reopened the form - the 'Link' Field showed the
checkmark (and value -1) but 'List-Link' was still greyed out.



Any suggestions? Thank you very much.
 
Hi Elwood,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

You need to use the OnCurrent event of the form. In the code for that
event you can use a statement similar to the following:

If Me!Links <> 0 then
Me!Links.Enabled = True
Else
Me!LInks.Enabled = False
EndIf

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top