Printing a line depending on a field value

[Alp]

Hi all,

I have unsuccessfully tried to hide/print a line in a report depending on
the value of a field. The ".Visible" does not apply or at least I couldn't
get it to do so.

I am blocking the visibility of 0 field value by conditional formatting but
then I do need the line (a diagonal one) to print in place (or over) of the
field.

I would appreciate any help/ideas.

Thanks in advance

Alp

 

[Allen Browne]

In the Format event procedure of the section:

Me.[Line0].Visible = IsNull(Me.[SomeTextbox])

 

[Alp]

Thanks Allen. But; it seems like I am missing the .Visible option some
how...
Normally, while I am writing VB code, this helper box comes up indicating
the choices that I have. When I key in "Me.Cizgi1." it does come up but does
not have the Visible as an option. Am I missing a resource? I am using 2002
in 2000 mode for the database with OLE Automation, MA ActiveX DO 2.1 Lib, MS
DAO 3.6 OL, VBA and MS Access 10.0 OL as resources. Do I need to include
another?

I do have the option while dealing with forms though.

Thanks for your time.

Alp

In the Format event procedure of the section:

Me.[Line0].Visible = IsNull(Me.[SomeTextbox])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have unsuccessfully tried to hide/print a line in a report depending on
the value of a field. The ".Visible" does not apply or at least I couldn't
get it to do so.

I am blocking the visibility of 0 field value by conditional formatting but
then I do need the line (a diagonal one) to print in place (or over) of the
field.

 

[Allen Browne]

Try setting it anyway. Intellisense sometimes misses the Visible property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen. But; it seems like I am missing the .Visible option some
how...
Normally, while I am writing VB code, this helper box comes up indicating
the choices that I have. When I key in "Me.Cizgi1." it does come up but does
not have the Visible as an option. Am I missing a resource? I am using 2002
in 2000 mode for the database with OLE Automation, MA ActiveX DO 2.1 Lib, MS
DAO 3.6 OL, VBA and MS Access 10.0 OL as resources. Do I need to include
another?

I do have the option while dealing with forms though.

Thanks for your time.

Alp

In the Format event procedure of the section:

Me.[Line0].Visible = IsNull(Me.[SomeTextbox])

I have unsuccessfully tried to hide/print a line in a report depending on
the value of a field. The ".Visible" does not apply or at least I couldn't
get it to do so.

I am blocking the visibility of 0 field value by conditional

formatting
but

then I do need the line (a diagonal one) to print in place (or over)

of
the

field.

 

[Alp]

Thanks a lot! I should have guessed that by now... being a MS user for ages
and having known how efficient! its help stuff are... Sorry, no offences
please...

Yep, I finally managed to get it done. Thanks again Allen and a belated
Happy New Year to DownUnder from Malaysia!

Alp

Try setting it anyway. Intellisense sometimes misses the Visible property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen. But; it seems like I am missing the .Visible option some
how...
Normally, while I am writing VB code, this helper box comes up indicating
the choices that I have. When I key in "Me.Cizgi1." it does come up but does
not have the Visible as an option. Am I missing a resource? I am using 2002
in 2000 mode for the database with OLE Automation, MA ActiveX DO 2.1

Lib,

MS
DAO 3.6 OL, VBA and MS Access 10.0 OL as resources. Do I need to include
another?

I do have the option while dealing with forms though.

Thanks for your time.

Alp

In the Format event procedure of the section:

Me.[Line0].Visible = IsNull(Me.[SomeTextbox])


I have unsuccessfully tried to hide/print a line in a report

depending
on

the value of a field. The ".Visible" does not apply or at least I couldn't
get it to do so.

I am blocking the visibility of 0 field value by conditional formatting
but
then I do need the line (a diagonal one) to print in place (or over) of
the
field.