Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-20-2019, 03:05 PM   #1
AccOUCH
Newly Registered User
 
Join Date: Sep 2018
Posts: 25
Thanks: 23
Thanked 0 Times in 0 Posts
AccOUCH is on a distinguished road
Change the control Source in a textbox in a Report.

Change the Control Source of a TextBox in a report. Like the one shown in this image:


Screen capture

My aim is to exclude from this control results that are compabtile with the string above depicted so I've written:

Code:
=[FormaPago] <> "Transferencias SVS-Mutuas"
But it does not work. So my question to all the community is clear: How to prevent some strings that show the kind of FormaPago (there are several) to be printed in the report.

Why the way I've used is not correct? How to solve this?

AccOUCH is offline   Reply With Quote
Old 09-20-2019, 03:24 PM   #2
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,422
Thanks: 0
Thanked 567 Times in 563 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Change the control Source in a textbox in a Report.

=IIf([FormaPago] = "Transferencias SVS-Mutuas", Null, [FormaPago])

Or apply filter criteria to report so those records are not retrieved.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Old 09-21-2019, 12:24 AM   #3
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,568
Thanks: 68
Thanked 2,744 Times in 2,629 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Change the control Source in a textbox in a Report.

use Conditional Formatting.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 09-21-2019, 12:37 AM   #4
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,422
Thanks: 0
Thanked 567 Times in 563 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Change the control Source in a textbox in a Report.

@arnelgp, could you clarify how CF applies?

__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Reply

Tags
control source , report , textbox

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
IIF Statement in report - Textbox control source AnitaPita Reports 10 07-23-2015 10:56 AM
Change Control Source of Report pnpez Queries 2 01-05-2012 09:30 AM
Change textbox fore color from Control Source property mixail Forms 3 09-20-2010 03:50 PM
How do I change a textbox's control source while a form is open? radhika1990 Forms 1 07-24-2009 10:10 AM
Control Source on report won't change skwilliams Reports 2 09-13-2004 06:04 AM




All times are GMT -8. The time now is 09:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World