473,574 Members | 2,982 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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**********@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

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

Nov 13 '05 #4
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



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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

19
6868
by: dmiller23462 | last post by:
Hi guys....I have absolutely NO IDEA what I'm doing with Javascript but my end result is I need two text boxes to stay hidden until a particular option is selected....I've cobbled together the JavaScript in this code from a couple different sites but I'm not 100% sure what each line is doing...This is the ASP code that I'm using for the...
2
5574
by: Jayjay | last post by:
I've got a report that has a series of unbound text boxes that are being populated by some variables in code. The format is supposed to be a currancy format, but on a certain series of boxes, I need add " ** " or something to denote those particular boxes so they can get the reader to see the footnote for those figures. The report is...
11
16225
by: Edson Peacock | last post by:
I have a report with sub reports, one of the subreports have 12 text boxes that are 2" high and I want them all to grow if one goes to 3" high. If anyone has any suggestions they are very much appreciated. Thanks
4
4067
by: ckpoll2 | last post by:
Hello, I have a report and am having a hard time summing some numbers. In the detail section of the report, I have 2 text boxes that have IIF statements in them. These IIF statements return numbers, either a positive number or 0. In the Name Footer, I am trying to sum all the occurrances of Text18 and Text19, the two IIF text boxes in the...
10
11739
by: sara | last post by:
Hi - Is it possible to hide the detail section of a report at run time? I have a report that prints all details, with summary lines. The user would like the report ALSO with just summary lines. It seems the simplest thing is to run the code (see below) once with the detail section showing, and a second time hiding the detail section. I...
4
2280
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post by:
I have created a report. This report needs to display records between two dates entered by the user. I put two text boxes on the report so I can enter the start and end date - I set them to use an input mask of 'short date' format. The problem is that when I enter anything in these text boxes, as soon as the field looses focus, the text is...
7
13369
by: NJonge01 | last post by:
Hi, I'd like to produce a report that basically looks like an excel printout. Description: Profile Print Report Detail Section with 3 bordered text boxes all text boxes are 'abutted' against each other (where one ends, the next begins) all text boxes have the 'can grow' property set to yes. Detail Section with 'can grown' = yes
6
2547
by: noe1818 via AccessMonster.com | last post by:
Just a quick question about lines: Is it possible to connect a text box (e.g. txtbx1 to txtbx2 and txtbx2 to txtbx3) with lines where txtbx1,2,&3 move up or down according to their values? Like have access find the location of each txtbx and draw a line from it to the other textbox? Thanks --
5
7762
by: ofilha | last post by:
I have created a report in design mode. However, some of the fields i need are dynamic. That is, i have a series of fields text boxes mostly that must show up only as needed. I also have some labels that also should dynamic depending on the text boxes. I first tried createReportcontrol during the OnOpen event for the report,and when i tried...
0
8052
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8234
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7815
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8098
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6452
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5620
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3740
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3749
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1339
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.