Conditinal formatting for control (continuous forms)

[quiksilver1804]

I have a continuous form and want to display 6 buttons. I want the buttons to display depending on if there is a value in a certain field or not..

fields "DocNum1" thru "DocNum6" from TCD_RequestedCRDB

I was told that the Visible property doesn't work for individual records on continuous forms (that it will affect all records).

Is this true? i tried and couldn't get it to work..

 

[Pat Hartman]

A trick you can use with conditional formatting is to change the foreground color to be the same as the background color. This effectively hides any text in the field. There is limited color control with conditional formatting so your background color has to be one of the standard ones.

 

[Cosmos75]

I have a continuous form and want to display 6 buttons. I want the buttons to display depending on if there is a value in a certain field or not..

Why do you need 6 buttons for each record?
What do they do?
Why cant you have 6 buttons in the form's footer or header and have them perform an action for the currently selected record? You could disable and enable them depending on the current record meeting certain condition.


I apologize for all the questions that I asked. It's just that I've never had the need to have command buttons for each record and you may have thought of something that I haven't. Or where you talking about an option button or toggle button?

I was told that the Visible property doesn't work for individual records on continuous forms (that it will affect all records).

Is this true? i tried and couldn't get it to work..

Yup, see here.
ACC: Changing Control Properties Affects All Records in a Form
http://support.microsoft.com/kb/119992/


As Pat said, you can use conditional formatting, but you are limited to 3 conditions and is only available for Access 200 and hight. But if you have Access 2000 and 3 conditions is enough, great! But if you need more, you might give this a try
- 'Conditional Formating' of controls in a continuous form