Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-21-2019, 02:50 AM   #1
solnajeff
Newly Registered User
 
Join Date: May 2007
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
solnajeff is on a distinguished road
Hiding report elements in report view

Hi

I have a report that is used for printing tests for trainees. One test involves the addition of between one and three variables. In the printed version the addition signs that are not required can be removed using Detail_Print or Detail_Format.

However as I intend to also administer tests using the computer I would like to remove unnecessary addition signs from the report view. The report is embedded in a form but 'Detail' code is not executed when the embedded report is loaded.

I did try changing the default report view to print preview for the embedded report but that did not have any effect.

If anyone has come across this before I would be grateful for any advice.

Regards

Jeff

solnajeff is offline   Reply With Quote
Old 05-21-2019, 03:09 AM   #2
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,336
Thanks: 158
Thanked 1,699 Times in 1,670 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Hiding report elements in report view

Is the field is a calculated one , something like

Code:
ReportValue: [Field1] & "+" & [Field2] & "+" & [Field3]
?
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 05-21-2019, 04:58 AM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 9,834
Thanks: 107
Thanked 2,662 Times in 2,435 Posts
isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all
Re: Hiding report elements in report view

If the report is embedded in a form then neither report view nor print preview will be used.
It will be subject to whichever view your form is in. Form view or layout view

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 05-21-2019, 07:45 AM   #4
solnajeff
Newly Registered User
 
Join Date: May 2007
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
solnajeff is on a distinguished road
Re: Hiding report elements in report view

Hi

No the format is "expression 1" "+" "expression 2" "+" "expression 3", no calculations involved

The expressions are text only which the trainee has to calculate mentally and then add together. The number of expressions may be one or two or three, however if one or two I am left with unwanted addition signs that I wish to hide.

When printing this is no problem as it is done in Detail Print, but I cannot workout if it is possible to hide in report view

Regards

Jeff
solnajeff is offline   Reply With Quote
Old 05-21-2019, 08:28 AM   #5
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,357
Thanks: 20
Thanked 892 Times in 877 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: Hiding report elements in report view

Hmm, try...

[expression 1] & (” “+[expression 2]) & (” “+[expression 3])

Edit: If the first expression can be left blank you want to use...

LTrim([expression 1] & (” “+[expression 2]) & (” “+[expression 3]))
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by GinaWhipp; 05-21-2019 at 08:30 AM. Reason: Add to post
GinaWhipp is online now   Reply With Quote
Old 05-21-2019, 10:54 PM   #6
solnajeff
Newly Registered User
 
Join Date: May 2007
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
solnajeff is on a distinguished road
Re: Hiding report elements in report view

Hi

Thanks for the advice, unfortunately it is the third and second that would be blank. However it did give me the idea to add the addition signs at the time of the test creation rather than at the report stage and now it displays correctly.

Many thanks for all your input

Regards

Jeff
solnajeff is offline   Reply With Quote
Old 05-22-2019, 03:47 PM   #7
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,357
Thanks: 20
Thanked 892 Times in 877 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: Hiding report elements in report view

What I gave you should show nothing if any one of them is blank leaving you only with the one that is actually filled in. Are you saying that is not what is happening?


__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide report elements conditionally jeffreyccs Reports 5 03-28-2019 06:50 AM
How do I pull elements from a table to a report? Access9001 Reports 0 07-29-2011 11:34 AM
Report elements verticle rather than horizontal? haydenal Reports 1 05-27-2009 01:09 PM
Keeping report elements together MatMac Reports 5 04-09-2009 05:12 AM
Hide Elements on a Report airforceruss Reports 13 02-13-2009 01:08 PM




All times are GMT -8. The time now is 12:09 PM.


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