Detail:On Format visibility question

[btnel1]

I saw in these posts info on how to display one field based on another, I've writ the below code, but I'm getting an error that I can't troubleshoot...


Code:
= [field1].Visible = ([field2].Value IN ('AL', 'G1', 'V1'))
[field3].[Visible] = [field1].[Visible]
[field4].[Visible] = [field1].[Visible]


Can anyone help me find the invalid syntax?

 

[theDBguy]

Hi. Where exactly is this code placed? By having an equal sign at the beginning, it looks like it's a Control Source for a Textbox.

 

[btnel1]

I have the code in the Detail, On Format event

 

[theDBguy]

I have the code in the Detail, On Format event

Okay, can you please post the complete section code? Maybe the syntax error is because of the equal sign at the beginning.

 

[btnel1]

Here is the code, thanks so much!


[no interest 24 term price].Visible = ([Commission Code].Value IN ('AL', 'G1', 'V1'))
[finance label].[Visible] = [no interest 24 term price].[Visible]
[Finance label 2].[Visible] = [no interest 24 term price].[Visible]

 

[theDBguy]

Here is the code, thanks so much!

[no interest 24 term price].Visible = ([Commission Code].Value IN ('AL', 'G1', 'V1'))
[finance label].[Visible] = [no interest 24 term price].[Visible]
[Finance label 2].[Visible] = [no interest 24 term price].[Visible]

Okay, thanks. And you're saying the above is giving you a syntax error, correct? If so, try commenting out the first line and see if the error goes away. If so, then I think the problem is in the IN() part. Try breaking them out separately using an OR construct.