disabling labels (or other controllers) in a continuous form

[I.A.]

Hi


this is supposed to be fairly easy but I cant seem to get it to work...
I have a continuous form with multiple rows from a query. The form "repeats" itself for every row.
I wish to make the label called label1 invisible if the variable Type on the same row is equal to 2 and to apply this check for each row.

I wrote a few lines:

If Me.Type = 2 Then
    Me.label1.Visible = False
Endif

but this doesnt seem to work. I've tried to put it under many different form events but cant get it to work.

Any ideas?
Thanks!

[pbaldy]

The simplest way to get what you want is with Conditional Formatting (on the ribbon). I can't remember offhand if it works with labels, but if not you can get the same look with a textbox. The code solution you're trying will either check all rows or no rows. Code will work in a report in Preview or Print modes, but not in a form.

[I.A.]

First of all thanks for the quick reply!

I have to say this kinda sucks because I wanted it to work on some comboboxes as well .... anyway - good to know - wasted too much time on it as it is...

I will try to see if I can make them merge in the background.

[pbaldy]

Conditional Formatting will also work with combo boxes. Welcome to the site by the way!

[I.A.]

Thanks!
It seems Conditional formatting cannot apply to labels.
Is there a way through code to make the form more dynamic - I really don't want to leave empty fields when they are not needed. otherwise the only thing I can do is divide the table into 2 tables which seems excessive...

[pbaldy]

Leaving fields empty implies a design problem. What do the fields in the table represent?

[I.A.]

I hope I can relay my intent....

I have a primary table of products.

A second table with possible actions - ActionList.

The table the form is based on contains the instructions for manufacturing a specific product, hence the fields are:
productID (linked to product table)
ManufacturOrder
ActionID (linked to ActionList)
Instructions
Ingredient

The problem is that some actions do not require an ingredient so I wanted it not to appear. It must be a continuous form so the user can see all the actions and edit them or their order.

Since your last post stated this is not possible I added some code lines to check that no one put it an ingredient with an action that doesnt require it and vice versa. I'm afraid any design change let me see all the actions together and in the right order.

[pbaldy]

That doesn't seem too bad. Like I said earlier, you can use a textbox instead of a label, and then use CF.