Hide and Display field in report

[LDMueller]

I have Access 2003. I have a field on my report named RELATED. I only want
the field to show if RELATED = CON or CIP or DIV. Otherwise, I don't want it
visible.

I'm thinking I should add a text box with Control Source, but I'm not sure
I'm correct and if I am, I don't know what the Control Source should be.

Thanks!

 

[Ofer Cohen]

In the OnPrint event of the section where the text box is located in write
the code

Me.[RELATED].Visible = (Me.RELATED = "CON" or Me.RELATED = "CIP" or
Me.RELATED = "DIV")

It will set the visible True Or false depend on the criteria

 

[LDMueller]

I tried this, but it didn't work. I found it odd that when I typed the
period after
"Me.[RELATED]." that Visible wasn't on the list. I'm limited to what I
know, but I though the only options available would be on the list.

Any thoughts?

Thanks!

In the OnPrint event of the section where the text box is located in write
the code

Me.[RELATED].Visible = (Me.RELATED = "CON" or Me.RELATED = "CIP" or
Me.RELATED = "DIV")

It will set the visible True Or false depend on the criteria

--
Good Luck
BS"D

I have Access 2003. I have a field on my report named RELATED. I only want
the field to show if RELATED = CON or CIP or DIV. Otherwise, I don't want it
visible.

I'm thinking I should add a text box with Control Source, but I'm not sure
I'm correct and if I am, I don't know what the Control Source should be.

Thanks!

 

[Ofer Cohen]

The Visible doesn't apear on the list but it should work.

Did you try it?
What did you get?

--
Good Luck
BS"D

I tried this, but it didn't work. I found it odd that when I typed the
period after
"Me.[RELATED]." that Visible wasn't on the list. I'm limited to what I
know, but I though the only options available would be on the list.

Any thoughts?

Thanks!

In the OnPrint event of the section where the text box is located in write
the code

Me.[RELATED].Visible = (Me.RELATED = "CON" or Me.RELATED = "CIP" or
Me.RELATED = "DIV")

It will set the visible True Or false depend on the criteria

--
Good Luck
BS"D

I have Access 2003. I have a field on my report named RELATED. I only want
the field to show if RELATED = CON or CIP or DIV. Otherwise, I don't want it
visible.

I'm thinking I should add a text box with Control Source, but I'm not sure
I'm correct and if I am, I don't know what the Control Source should be.

Thanks!

 

[LDMueller]

First, thanks for letting me know about the list.

Yes I tried it, but it didn't work. I'm thinking this is my fault because
perhaps I'm not giving you enough information so let me explain it better.

I have a field on my report named RELATED. I only want the field to show if
the field CONTINUED = CON or CIP or DIV.

Sorry about the misinformation.

Thanks!

The Visible doesn't apear on the list but it should work.

Did you try it?
What did you get?

--
Good Luck
BS"D

I tried this, but it didn't work. I found it odd that when I typed the
period after
"Me.[RELATED]." that Visible wasn't on the list. I'm limited to what I
know, but I though the only options available would be on the list.

Any thoughts?

Thanks!

In the OnPrint event of the section where the text box is located in write
the code

Me.[RELATED].Visible = (Me.RELATED = "CON" or Me.RELATED = "CIP" or
Me.RELATED = "DIV")

It will set the visible True Or false depend on the criteria

--
Good Luck
BS"D


:

I have Access 2003. I have a field on my report named RELATED. I only want
the field to show if RELATED = CON or CIP or DIV. Otherwise, I don't want it
visible.

I'm thinking I should add a text box with Control Source, but I'm not sure
I'm correct and if I am, I don't know what the Control Source should be.

Thanks!

 

[Ofer Cohen]

OK, you can use the first example

Me.[RELATED].Visible = (Me.CONTINUED = "CON" or Me.CONTINUED = "CIP" or
Me.CONTINUED = "DIV")

This code need to be in the OnPrint event of the section where RELATED field
is located in
If the Criteria will return True then it will be visible, and the other way
around

--
Good Luck
BS"D

First, thanks for letting me know about the list.

Yes I tried it, but it didn't work. I'm thinking this is my fault because
perhaps I'm not giving you enough information so let me explain it better.

I have a field on my report named RELATED. I only want the field to show if
the field CONTINUED = CON or CIP or DIV.

Sorry about the misinformation.

Thanks!

The Visible doesn't apear on the list but it should work.

Did you try it?
What did you get?

--
Good Luck
BS"D

I tried this, but it didn't work. I found it odd that when I typed the
period after
"Me.[RELATED]." that Visible wasn't on the list. I'm limited to what I
know, but I though the only options available would be on the list.

Any thoughts?

Thanks!

:

In the OnPrint event of the section where the text box is located in write
the code

Me.[RELATED].Visible = (Me.RELATED = "CON" or Me.RELATED = "CIP" or
Me.RELATED = "DIV")

It will set the visible True Or false depend on the criteria

--
Good Luck
BS"D


:

I have Access 2003. I have a field on my report named RELATED. I only want
the field to show if RELATED = CON or CIP or DIV. Otherwise, I don't want it
visible.

I'm thinking I should add a text box with Control Source, but I'm not sure
I'm correct and if I am, I don't know what the Control Source should be.

Thanks!

 

[LDMueller]

Again, thank you so much. I added the code to the OnPrint event of the
section where RELATED field is located. In my report, it's the Title header
section. It's this way because of sorting and grouping.

When I try to View or Print, nothing happens.

OK, you can use the first example

Me.[RELATED].Visible = (Me.CONTINUED = "CON" or Me.CONTINUED = "CIP" or
Me.CONTINUED = "DIV")

This code need to be in the OnPrint event of the section where RELATED field
is located in
If the Criteria will return True then it will be visible, and the other way
around

--
Good Luck
BS"D

First, thanks for letting me know about the list.

Yes I tried it, but it didn't work. I'm thinking this is my fault because
perhaps I'm not giving you enough information so let me explain it better.

I have a field on my report named RELATED. I only want the field to show if
the field CONTINUED = CON or CIP or DIV.

Sorry about the misinformation.

Thanks!

The Visible doesn't apear on the list but it should work.

Did you try it?
What did you get?

--
Good Luck
BS"D


:

I tried this, but it didn't work. I found it odd that when I typed the
period after
"Me.[RELATED]." that Visible wasn't on the list. I'm limited to what I
know, but I though the only options available would be on the list.

Any thoughts?

Thanks!

:

In the OnPrint event of the section where the text box is located in write
the code

Me.[RELATED].Visible = (Me.RELATED = "CON" or Me.RELATED = "CIP" or
Me.RELATED = "DIV")

It will set the visible True Or false depend on the criteria

--
Good Luck
BS"D


:

I have Access 2003. I have a field on my report named RELATED. I only want
the field to show if RELATED = CON or CIP or DIV. Otherwise, I don't want it
visible.

I'm thinking I should add a text box with Control Source, but I'm not sure
I'm correct and if I am, I don't know what the Control Source should be.

Thanks!