Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-06-2010, 03:07 PM   #1
Perissos
Newly Registered User
 
Join Date: Jun 2010
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Perissos is on a distinguished road
Can you have shapes on reports?

Is there an easy way to add a shape to an Access report without inserting an image?

Perissos is offline   Reply With Quote
Old 07-06-2010, 03:11 PM   #2
vbaInet
AWF VIP
 
Join Date: Jan 2010
Location: U.K.
Posts: 26,374
Thanks: 0
Thanked 2,423 Times in 2,389 Posts
vbaInet is a name known to all vbaInet is a name known to all vbaInet is a name known to all vbaInet is a name known to all vbaInet is a name known to all vbaInet is a name known to all
Re: Can you have shapes on reports?

You can draw a circle or a line. What's the purpose of this by the way?
vbaInet is offline   Reply With Quote
Old 07-06-2010, 03:28 PM   #3
Perissos
Newly Registered User
 
Join Date: Jun 2010
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Perissos is on a distinguished road
Re: Can you have shapes on reports?

odd.. I don't see shapes in my object list. I'll take another look.

What I would like to do is have an oval shape and attach an if statement to it to change the background color if a certain condition exists.

Perissos is offline   Reply With Quote
Old 07-06-2010, 03:37 PM   #4
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,828 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: Can you have shapes on reports?

I do believe that a line or a rectangle are your only options. No circles exist.

Attached Images
File Type: png linesquare.png (9.5 KB, 4917 views)
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 07-06-2010, 04:07 PM   #5
Perissos
Newly Registered User
 
Join Date: Jun 2010
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Perissos is on a distinguished road
Re: Can you have shapes on reports?

phew.. thought I was missing something, lol. Thanks.
Perissos is offline   Reply With Quote
Old 07-06-2010, 05:42 PM   #6
Perissos
Newly Registered User
 
Join Date: Jun 2010
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Perissos is on a distinguished road
Re: Can you have shapes on reports?

My brain is fried I think...

I thought I could easily do this by using an if statment and referencing the field on the report, but I get an error 2424 "The expression you entered has a field, control, or property name that Microsoft Access can't find."

I wont be able to do this will I? At least not the way I am thinking.

On the report open event I put
If me.txtamt.value = 0 then
me.imgred.visible = true
end if

Will I have to create a recordset based off the original query to get the value of the field and use that variable to set the image?
Perissos is offline   Reply With Quote
Old 07-06-2010, 06:17 PM   #7
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,828 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: Can you have shapes on reports?

Use the On Format event of the section the text box is in, not the open event.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 07-07-2010, 01:58 AM   #8
Perissos
Newly Registered User
 
Join Date: Jun 2010
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Perissos is on a distinguished road
Re: Can you have shapes on reports?

Got it. Thank you so very much!

Perissos is offline   Reply With Quote
Reply

Tags
image , shape

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Automate printing of access reports jgsketch Reports 1 08-25-2006 03:34 AM
How to use Crystal reports in Access application. Bosch General 0 02-03-2006 03:38 PM
Print all reports with one command button Mike Hughes Reports 1 03-19-2003 12:39 PM
Importing reports and query source rpadams General 2 03-14-2003 11:29 AM
run reports without printing them y2k Macros 1 11-26-2002 04:02 PM




All times are GMT -8. The time now is 10:50 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