Problems with continous form view - No control Instance!

[rafal444]

I have a main form and subform showing all the related records. It is one to many relationship, so i am showing the subform as continous form

The problem is that if I want to hide certain fields based on the type of record, it hides field for all records. That is not acceptable, since each record would have different type. I figured I need to access instance of teh control for particular record. Something like MyControl(Current Instance).Visible= False. I am not sure what the syntax would be.

Here is my code from Continous Form (hides field for all records):

Select Case cboRoleAType.Value
Case "Distributor"
Me.SalesAgentID_RoleA.Visible = False
Me.DistributorID_RoleA.Visible = True
Case "Sales Agent"
Me.SalesAgentID_RoleA.Visible = True
Me.DistributorID_RoleA.Visible = False
End Select

Seems like .Visible works for all records and once, however .Value returns correct value... Is it a bug in Access?

 

[jkl0]

You might try conditional formating but your options may be slightly limited.

 

[rafal444]

Tahnks. I do not know anything about conditional formating, how would I use it exactly for the example above? Will it work?

 

[rafal444]

There is no Visibl property in Conditional Formatting, only "Enabled". I do not want to show some fields based on the type combo box. How to do this?

 

[jkl0]

A quick and dirty way to use the Conditional Formatting would be to disable the field and change the font color to the background color.

Maybe someone else may have a better method?

 

[rafal444]

The problem is that the background is a picture. Can I make background color transparent? What is the color value for transparent?

This seems like serious limitation in Access. This is the second one I have nticed o far. The first one was that the contionous foprm can not have a subform...