Hide text boxes on a report

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

re: Hide text boxes on a report

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.visible = True
else
Me!TextBox.visible = False
end if

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

--
Hope this helps
Arno R



"Mark" <mark.reeed75@ntlworld.com> schreef in bericht news:0PU1e.361$O_3.332@newsfe3-win.ntli.net...[color=blue]
> 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
>
>[/color]

re: Hide text boxes on a report

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" <mark.reeed75@ntlworld.com> schrieb im Newsbeitrag
news:0PU1e.361$O_3.332@newsfe3-win.ntli.net...[color=blue]
> 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[/color]
to[color=blue]
> display "" but I would really like to hide the text box. I was hoping to[/color]
do[color=blue]
> this with conditional formatting but as far as I can see, you cannot[/color]
change[color=blue]
> borders this way.
>
> Has anyone got any ideas?
>
> TIA
>
> Mark
>
>[/color]

re: Hide text boxes on a report

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" <arracomn_o_s_p_a_m@tiscali.nl> wrote in message
news:42482341$0$44102$5fc3050@dreader2.news.tiscal i.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.visible = True
else
Me!TextBox.visible = False
end if

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

--
Hope this helps
Arno R



"Mark" <mark.reeed75@ntlworld.com> schreef in bericht
news:0PU1e.361$O_3.332@newsfe3-win.ntli.net...[color=blue]
> 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
>
>[/color]

re: Hide text boxes on a report

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

Private Sub Details_Print(Cancel As Integer, PrintCount As Integer)
If Me!WhateverField.condition =True then
Me!TextBox1.visible = True
else
Me!TextBox.visible = False
end if
end sub

--
Hope this helps
Arno R



"Mark" <mark.reeed75@ntlworld.com> schreef in bericht news:sKW1e.4$c4.1@newsfe3-win.ntli.net...[color=blue]
> 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" <arracomn_o_s_p_a_m@tiscali.nl> wrote in message
> news:42482341$0$44102$5fc3050@dreader2.news.tiscal i.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.visible = True
> else
> Me!TextBox.visible = False
> end if
>
> Or even in 1 line: Me!TextBox.visible = Condition
>
> --
> Hope this helps
> Arno R
>
>
>
> "Mark" <mark.reeed75@ntlworld.com> schreef in bericht
> news:0PU1e.361$O_3.332@newsfe3-win.ntli.net...[color=green]
>> 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
>>
>> [/color]
>
>[/color]

re: Hide text boxes on a report

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" <mark.reeed75@ntlworld.com> wrote in message
news:0PU1e.361$O_3.332@newsfe3-win.ntli.net...[color=blue]
> 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[/color]
to[color=blue]
> display "" but I would really like to hide the text box. I was hoping to[/color]
do[color=blue]
> this with conditional formatting but as far as I can see, you cannot[/color]
change[color=blue]
> borders this way.
>
> Has anyone got any ideas?
>
> TIA
>
> Mark
>
>
>[/color]




----== 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 =----

re: Hide text boxes on a report

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:42486753$1_2@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" <mark.reeed75@ntlworld.com> wrote in message
news:0PU1e.361$O_3.332@newsfe3-win.ntli.net...[color=blue]
> 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[/color]
to[color=blue]
> display "" but I would really like to hide the text box. I was hoping to[/color]
do[color=blue]
> this with conditional formatting but as far as I can see, you cannot[/color]
change[color=blue]
> borders this way.
>
> Has anyone got any ideas?
>
> TIA
>
> Mark
>
>
>[/color]




----== 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 =----

re: Hide text boxes on a report

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" <mark.reeed75@ntlworld.com> wrote in message
news:ZMZ1e.1238$_I5.45@newsfe5-win.ntli.net...[color=blue]
> The text box/s are filled with a zero length string. This doesn't have to[/color]
be[color=blue]
> 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[/color]
so[color=blue]
> 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:42486753$1_2@127.0.0.1...
> Will the text box be blank or empty if it is not used? I often use the[/color]
tag[color=blue]
> 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[/color]
I[color=blue]
> want to be able to hide if they are blank I set their tag propery to[/color]
include[color=blue]
> "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" <mark.reeed75@ntlworld.com> wrote in message
> news:0PU1e.361$O_3.332@newsfe3-win.ntli.net...[color=green]
> > Hi All,
> > I have a report which is based on a query which is used to produce[/color][/color]
QC[color=blue][color=green]
> > 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","[/color][/color]
Is[color=blue][color=green]
> > the outer label positioned correctly")
> >
> > My problem is that there are more questions for hanging types than[/color][/color]
boxed.[color=blue][color=green]
> > Where I have run out of questions for boxed, I have set the IIF[/color][/color]
statement[color=blue]
> to[color=green]
> > display "" but I would really like to hide the text box. I was hoping to[/color]
> do[color=green]
> > this with conditional formatting but as far as I can see, you cannot[/color]
> change[color=green]
> > borders this way.
> >
> > Has anyone got any ideas?
> >
> > TIA
> >
> > Mark
> >
> >
> >[/color]
>
>
>
>
> ----== 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[/color]
=----[color=blue]
>
>
>[/color]




----== 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 =----