Access Form with checkbox toggled textboxes to make visible

[Akihoshi]

im trying to make a form that has toggled textboxes based on checkboxes.

i have a lot of fields with data and i kinda want to clean it up so that only active fields are show when my workers are entering data on my form.

i have tried quite a few ways to get this done but hasn't worked yet.

here are some of the codes and events i have tried:

=IIf([toggle]="-1",[Data].[Visible]=True,[Data].[Visible]=False)

=IIf([toggle]="yes",[Data].[Visible]=True,[Data].[Visible]=False)

=IIf([test data toggle]="-1",[test Data].[Visible]=True,[test Data].[Visible]=False)

nothing has worked, did get an error saying object doesn't have automation object "Visible.'.

need some help.

[zmbd]

+ Version of Access?
+ Your level of expertise?
+ Consider multiple forms showing the proper fields for data entry based on the user.
+ You are not very clear as to where you have attempted to place your "code"
+ You do not use quotes around numerical values such as -1

[twinnyfo]

Akihoshi,

Try something like this:

Me.txtData1.Visible = me.chkBox1

This would be put in an after update event for your check box. However, you say you have many fields, so this can become cumbersome. There are ways to cycle through your controls. But, you have provided very litte information on what your form looks like, as Z has already stated.