problem finding conditional formatting!

[Kieran the Fish]

Hi

I want to make a field and data label transparent on a report if the field
is a null string / blank. using MS Access 2000 9.0 SP-3

Incredibly despite the help listing what to do, when I highlight the control
and seek the format properties, there is no listing or option for conditional
formatting!

Any help much appreciated, even if it is a workaround using another
technique...

Thanks

 

[fredg]

Hi

I want to make a field and data label transparent on a report if the field
is a null string / blank. using MS Access 2000 9.0 SP-3

Incredibly despite the help listing what to do, when I highlight the control
and seek the format properties, there is no listing or option for conditional
formatting!

Any help much appreciated, even if it is a workaround using another
technique...

Thanks

It's not on the property sheet.

In Design View, Select the control.
Then either ....
Click Format + Conditional Formatting (on the main tool menu)
or..
Right-click and select Conditional Formatting.

 

[fredg]

It's not on the property sheet.

In Design View, Select the control.
Then either ....
Click Format + Conditional Formatting (on the main tool menu)
or..
Right-click and select Conditional Formatting.

Whoops!
I told you how to find a control's conditional formatting, but it wont
make a label not visible if that is what you want (though I suppose
you could simply change the fontcolor to match the control's back
color).

Instead of Conditional Formatting, code the Format event of whatever
section of the report the control is in:
Me![LabelName].Visible = Not IsNull(Me![ControlName]))

 

[Kieran the Fish]

Hi Fred

That is excellent but you are right about the label. Sorry to ask again bt I
am not sure I understand the piece about the format code - where do I insert
this?

Thanks; your help is much appreciated :0)

Kieran

It's not on the property sheet.

In Design View, Select the control.
Then either ....
Click Format + Conditional Formatting (on the main tool menu)
or..
Right-click and select Conditional Formatting.

Whoops!
I told you how to find a control's conditional formatting, but it wont
make a label not visible if that is what you want (though I suppose
you could simply change the fontcolor to match the control's back
color).

Instead of Conditional Formatting, code the Format event of whatever
section of the report the control is in:
Me![LabelName].Visible = Not IsNull(Me![ControlName]))

 

[Kieran the Fish]

Correction!

Hi Fredg

I have worked out how to write and run the Macro and that is working fine
but whilst it is triggered by the OnFormat event on the Report, it does not
trigger when I look for the report from the User Menu (autoexec). It works
fine when I look for the report myself, which is very confusing!

Hi Fred

That is excellent but you are right about the label. Sorry to ask again bt I
am not sure I understand the piece about the format code - where do I insert
this?

Thanks; your help is much appreciated :0)

Kieran

On Tue, 23 Aug 2005 03:09:02 -0700, Kieran the Fish wrote:

Hi

I want to make a field and data label transparent on a report if the field
is a null string / blank. using MS Access 2000 9.0 SP-3

Incredibly despite the help listing what to do, when I highlight the control
and seek the format properties, there is no listing or option for conditional
formatting!

Any help much appreciated, even if it is a workaround using another
technique...

Thanks

It's not on the property sheet.

In Design View, Select the control.
Then either ....
Click Format + Conditional Formatting (on the main tool menu)
or..
Right-click and select Conditional Formatting.

Whoops!
I told you how to find a control's conditional formatting, but it wont
make a label not visible if that is what you want (though I suppose
you could simply change the fontcolor to match the control's back
color).

Instead of Conditional Formatting, code the Format event of whatever
section of the report the control is in:
Me![LabelName].Visible = Not IsNull(Me![ControlName]))