473,320 Members | 1,953 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Report Control

Hey,

I have a report with multiple records and controls. There is one
particular control called 'Further Reference' which is part of the
report. It has a couple of standard phrases in it and what i want to
happen is when the phrase "see catalogue copy" is selected for that
record, the control needs to disappear so no text appears on that
record of the report. If the record after that contains a different
statement then it needs to appear again.

Thank you in advance for your help.

Regards,

Christina

Jul 5 '06 #1
3 1370
Set the Control Source of this text box to:
=IIf([Further Reference] = "see catalogue copy", Null, [Further
Reference])

Then change the Name property of the text box as well. It cannot have the
same name as a field, e.g. it cannot be named Further Reference.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ch*******@hotmail.comwrote in message
news:11**********************@j8g2000cwa.googlegro ups.com...
>
I have a report with multiple records and controls. There is one
particular control called 'Further Reference' which is part of the
report. It has a couple of standard phrases in it and what i want to
happen is when the phrase "see catalogue copy" is selected for that
record, the control needs to disappear so no text appears on that
record of the report. If the record after that contains a different
statement then it needs to appear again.

Jul 5 '06 #2

Create a on_format event for the section of the report the control is
in (probably the Detail section)
In the code write something like:

'WARNING Air code follows!
If me.[Further Reference].Value = "see catalog copy" Then
me.[Further Reference].Visible = False
Else
me.[Further Reference].Visible = True
End If

Hope that helps

ch*******@hotmail.com wrote:
Hey,

I have a report with multiple records and controls. There is one
particular control called 'Further Reference' which is part of the
report. It has a couple of standard phrases in it and what i want to
happen is when the phrase "see catalogue copy" is selected for that
record, the control needs to disappear so no text appears on that
record of the report. If the record after that contains a different
statement then it needs to appear again.

Thank you in advance for your help.

Regards,

Christina
Jul 5 '06 #3
Thank you both so much for your help!!!

Much appreciative.

Jul 5 '06 #4

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

Similar topics

9
by: Colin McGuire | last post by:
Hi, I have an report in Microsoft Access and it displays everything in the table. One column called "DECISION" in the table has either 1,2, or 3 in it. On my report it displays 1, 2, or 3. I want...
1
by: last Name | last post by:
Hello all, I'm using Access 2000. I have a subreport control which loads a report in the detail section of a main report. I need to keep a count of each item price in the subreport and place it...
0
by: Chris | last post by:
I have the following situation in a VB.Net App I am working on: 1.)A report created in VS.Net 2003 using the CR.Net component of VS 2003. 2.)The datasource for the report is a Stored Proc in a...
0
by: jaykchan | last post by:
I am looking for a control that allows our users to expand and collapse rows in a report. Currently, the report is being shown in a web page generated from a CGI script. Unfortunately, the...
0
by: Tumurbaatar S. | last post by:
It's my first project using the Crystal report. I created a report with the report designer and linked it to a web form as: 1. put CrystalReportViewer in my page (its ID: Viewer). 2. put...
4
by: MLH | last post by:
I have a report and on it, a subreport control Main Report Name: rptInvoiceMain Sub Report Name: rptInvoiceSubReport SubReport Control Name: rptInvoiceSubReportCtl The...
2
by: john | last post by:
My report is based on a query with user input . In my report I have a text box with the following code: =. This works when the query outcome is 1 or more records. But when the query output is zero...
13
by: Greg | last post by:
Most suggestions on this topic recommend to use a page footer and make it visible only on the last page. My problem is that the footer is half of the height of a page which means the detail would...
3
by: Jimmy | last post by:
Is there a way to force access to wait a specified time before making a calculation? On my report there is a subreport with a number of calculation on it. One if which is a count of certain...
7
by: Sunil Korah | last post by:
Hi, I haven't used access reports much. I have a problem in getting the total of a group. I have 3 fields, ProgName (Program name), Pname (Participant's name) and PCategory (Participant...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.