Hide text boxes on a report

[Mark]

Hi All,
I have a report which is based on a query which is used to produce QC
check sheets. I have quite a few text boxes which are used to display
questions depending on the value of one particular field which will have
either a "H" or "B" value.

e.g. =IIf([ppactyp]="H"," Does the multipack Qty match the paperwork"," Is
the outer label positioned correctly")

My problem is that there are more questions for hanging types than boxed.
Where I have run out of questions for boxed, I have set the IIF statement to
display "" but I would really like to hide the text box. I was hoping to do
this with conditional formatting but as far as I can see, you cannot change
borders this way.

Has anyone got any ideas?

TIA

Mark

[Arno R]

Mark,
I don't quite understand what you are trying to do but if you would like to show / hide controls depending on a condition then you need something like:
If condition =True then
Me!TextBox1.vis ible = True
else
Me!TextBox.visi ble = False
end if

Or even in 1 line: Me!TextBox.visi ble = Condition

--
Hope this helps
Arno R

"Mark" <ma**********@n tlworld.com> schreef in bericht news:0P******** *******@newsfe3-win.ntli.net...

Hi All,
I have a report which is based on a query which is used to produce QC
check sheets. I have quite a few text boxes which are used to display
questions depending on the value of one particular field which will have
either a "H" or "B" value.

e.g. =IIf([ppactyp]="H"," Does the multipack Qty match the paperwork"," Is
the outer label positioned correctly")

My problem is that there are more questions for hanging types than boxed.
Where I have run out of questions for boxed, I have set the IIF statement to
display "" but I would really like to hide the text box. I was hoping to do
this with conditional formatting but as far as I can see, you cannot change
borders this way.

Has anyone got any ideas?

TIA

Mark

[Philipp]

Hey,

when you only want to hide textbox - you can write in the module an
if-statement and set the visible option true or false.
"Mark" <ma**********@n tlworld.com> schrieb im Newsbeitrag
news:0P******** *******@newsfe3-win.ntli.net...

Hi All,
I have a report which is based on a query which is used to produce QC
check sheets. I have quite a few text boxes which are used to display
questions depending on the value of one particular field which will have
either a "H" or "B" value.

e.g. =IIf([ppactyp]="H"," Does the multipack Qty match the paperwork"," Is
the outer label positioned correctly")

My problem is that there are more questions for hanging types than boxed.
Where I have run out of questions for boxed, I have set the IIF statement to display "" but I would really like to hide the text box. I was hoping to do this with conditional formatting but as far as I can see, you cannot change borders this way.

Has anyone got any ideas?

TIA

Mark

[Mark]

Hi Arno,
I know how to do this on forms using the method you've described but
firstly, an event does not exist on reports that will look at each page to
check the value of my IIF criteria (I think) and secondly, if I try to add
the code on the "On Open" event of the report, I get the message "Method or
Data member not found".

To reiterate my goal... I have several text boxes which I want either hidden
or the borders changed to transparent if a field on the report meets a set
criteria. When the report is run, there are on average 60 pages. 50% of
these will need the text boxes hidden.

Many thanks for your responses

Mark

"Arno R" <ar************ ****@tiscali.nl > wrote in message
news:42******** **************@ dreader2.news.t iscali.nl...
Mark,
I don't quite understand what you are trying to do but if you would like to
show / hide controls depending on a condition then you need something like:
If condition =True then
Me!TextBox1.vis ible = True
else
Me!TextBox.visi ble = False
end if

Or even in 1 line: Me!TextBox.visi ble = Condition

--
Hope this helps
Arno R

"Mark" <ma**********@n tlworld.com> schreef in bericht
news:0P******** *******@newsfe3-win.ntli.net...

Hi All,
I have a report which is based on a query which is used to produce QC
check sheets. I have quite a few text boxes which are used to display
questions depending on the value of one particular field which will have
either a "H" or "B" value.

e.g. =IIf([ppactyp]="H"," Does the multipack Qty match the paperwork"," Is
the outer label positioned correctly")

My problem is that there are more questions for hanging types than boxed.
Where I have run out of questions for boxed, I have set the IIF statement
to
display "" but I would really like to hide the text box. I was hoping to
do
this with conditional formatting but as far as I can see, you cannot
change
borders this way.

Has anyone got any ideas?

TIA

Mark

[Arno R]

Mark,
You must put similar code in the following event: >>> Details_Print

Private Sub Details_Print(C ancel As Integer, PrintCount As Integer)
If Me!WhateverFiel d.condition =True then
Me!TextBox1.vis ible = True
else
Me!TextBox.visi ble = False
end if
end sub

--
Hope this helps
Arno R

"Mark" <ma**********@n tlworld.com> schreef in bericht news:sK******** **@newsfe3-win.ntli.net...

Hi Arno,
I know how to do this on forms using the method you've described but
firstly, an event does not exist on reports that will look at each page to
check the value of my IIF criteria (I think) and secondly, if I try to add
the code on the "On Open" event of the report, I get the message "Method or
Data member not found".

To reiterate my goal... I have several text boxes which I want either hidden
or the borders changed to transparent if a field on the report meets a set
criteria. When the report is run, there are on average 60 pages. 50% of
these will need the text boxes hidden.

Many thanks for your responses

Mark

"Arno R" <ar************ ****@tiscali.nl > wrote in message
news:42******** **************@ dreader2.news.t iscali.nl...
Mark,
I don't quite understand what you are trying to do but if you would like to
show / hide controls depending on a condition then you need something like:
If condition =True then
Me!TextBox1.vis ible = True
else
Me!TextBox.visi ble = False
end if

Or even in 1 line: Me!TextBox.visi ble = Condition

--
Hope this helps
Arno R



"Mark" <ma**********@n tlworld.com> schreef in bericht
news:0P******** *******@newsfe3-win.ntli.net...

Hi All,
I have a report which is based on a query which is used to produce QC
check sheets. I have quite a few text boxes which are used to display
questions depending on the value of one particular field which will have
either a "H" or "B" value.

e.g. =IIf([ppactyp]="H"," Does the multipack Qty match the paperwork"," Is
the outer label positioned correctly")

My problem is that there are more questions for hanging types than boxed.
Where I have run out of questions for boxed, I have set the IIF statement
to
display "" but I would really like to hide the text box. I was hoping to
do
this with conditional formatting but as far as I can see, you cannot
change
borders this way.

Has anyone got any ideas?

TIA

Mark

[J. Clay]

Will the text box be blank or empty if it is not used? I often use the tag
property of text boxes to define when they will be hidden.

In one instance, in the detail section of a report, any of the text boxes I
want to be able to hide if they are blank I set their tag propery to include
"H". Then during the detail format event, I loop through all of my text
boxes on the report and check if they are blank and their tag property
includes "H". If so, I hide them.

Is this what you are looking for?
Jim

"Mark" <ma**********@n tlworld.com> wrote in message
news:0P******** *******@newsfe3-win.ntli.net...

Hi All,
I have a report which is based on a query which is used to produce QC
check sheets. I have quite a few text boxes which are used to display
questions depending on the value of one particular field which will have
either a "H" or "B" value.

e.g. =IIf([ppactyp]="H"," Does the multipack Qty match the paperwork"," Is
the outer label positioned correctly")

My problem is that there are more questions for hanging types than boxed.
Where I have run out of questions for boxed, I have set the IIF statement to display "" but I would really like to hide the text box. I was hoping to do this with conditional formatting but as far as I can see, you cannot change borders this way.

Has anyone got any ideas?

TIA

Mark

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[Mark]

The text box/s are filled with a zero length string. This doesn't have to be
the case, I just chose this so that nothing was displayed in the text box.
The next stage is hiding them. The tag property you refer to is new to me so
if your suggestion can be used, I'm afraid I'll need an idiots guide :o(

Thanks,

Mark

"J. Clay" <jim@N0_LCPmugs _Spam.com> wrote in message
news:42******** **@127.0.0.1...
Will the text box be blank or empty if it is not used? I often use the tag
property of text boxes to define when they will be hidden.

In one instance, in the detail section of a report, any of the text boxes I
want to be able to hide if they are blank I set their tag propery to include
"H". Then during the detail format event, I loop through all of my text
boxes on the report and check if they are blank and their tag property
includes "H". If so, I hide them.

Is this what you are looking for?
Jim

"Mark" <ma**********@n tlworld.com> wrote in message
news:0P******** *******@newsfe3-win.ntli.net...

Hi All,
I have a report which is based on a query which is used to produce QC
check sheets. I have quite a few text boxes which are used to display
questions depending on the value of one particular field which will have
either a "H" or "B" value.

e.g. =IIf([ppactyp]="H"," Does the multipack Qty match the paperwork"," Is
the outer label positioned correctly")

My problem is that there are more questions for hanging types than boxed.
Where I have run out of questions for boxed, I have set the IIF statement to display "" but I would really like to hide the text box. I was hoping to do this with conditional formatting but as far as I can see, you cannot change borders this way.

Has anyone got any ideas?

TIA

Mark

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[J. Clay]

Unable to responde extensively at this point, but you can search for Tag in
the help files and it will give you a start.

Jim

"Mark" <ma**********@n tlworld.com> wrote in message
news:ZM******** *******@newsfe5-win.ntli.net...

The text box/s are filled with a zero length string. This doesn't have to be the case, I just chose this so that nothing was displayed in the text box.
The next stage is hiding them. The tag property you refer to is new to me so if your suggestion can be used, I'm afraid I'll need an idiots guide :o(

Thanks,

Mark

"J. Clay" <jim@N0_LCPmugs _Spam.com> wrote in message
news:42******** **@127.0.0.1...
Will the text box be blank or empty if it is not used? I often use the tag property of text boxes to define when they will be hidden.

In one instance, in the detail section of a report, any of the text boxes I want to be able to hide if they are blank I set their tag propery to include "H". Then during the detail format event, I loop through all of my text
boxes on the report and check if they are blank and their tag property
includes "H". If so, I hide them.

Is this what you are looking for?
Jim

"Mark" <ma**********@n tlworld.com> wrote in message
news:0P******** *******@newsfe3-win.ntli.net...

Hi All,
I have a report which is based on a query which is used to produce QC check sheets. I have quite a few text boxes which are used to display
questions depending on the value of one particular field which will have
either a "H" or "B" value.

e.g. =IIf([ppactyp]="H"," Does the multipack Qty match the paperwork"," Is the outer label positioned correctly")

My problem is that there are more questions for hanging types than boxed. Where I have run out of questions for boxed, I have set the IIF

statement to

display "" but I would really like to hide the text box. I was hoping to do

this with conditional formatting but as far as I can see, you cannot

change

borders this way.

Has anyone got any ideas?

TIA

Mark

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption

=----

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----