469,271 Members | 1,787 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

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
Nov 13 '05 #1
7 9265
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" <ma**********@ntlworld.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

Nov 13 '05 #2
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**********@ntlworld.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

Nov 13 '05 #3
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.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" <ma**********@ntlworld.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

Nov 13 '05 #4
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" <ma**********@ntlworld.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.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" <ma**********@ntlworld.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



Nov 13 '05 #5
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**********@ntlworld.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 =----
Nov 13 '05 #6
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**********@ntlworld.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 =----
Nov 13 '05 #7
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**********@ntlworld.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**********@ntlworld.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 =----
Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by dmiller23462 | last post: by
2 posts views Thread by Jayjay | last post: by
4 posts views Thread by Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post: by
6 posts views Thread by noe1818 via AccessMonster.com | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.