Can you have shapes on reports? (1 Viewer)

Perissos

Registered User.
Local time
Today, 07:04
Joined
Jun 28, 2010
Messages
61
Is there an easy way to add a shape to an Access report without inserting an image?
 

vbaInet

AWF VIP
Local time
Today, 11:04
Joined
Jan 22, 2010
Messages
26,374
You can draw a circle or a line. What's the purpose of this by the way?
 

Perissos

Registered User.
Local time
Today, 07:04
Joined
Jun 28, 2010
Messages
61
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.
 

boblarson

Smeghead
Local time
Today, 04:04
Joined
Jan 12, 2001
Messages
32,059
I do believe that a line or a rectangle are your only options. No circles exist.

 

Attachments

  • linesquare.png
    linesquare.png
    9.5 KB · Views: 5,828

Perissos

Registered User.
Local time
Today, 07:04
Joined
Jun 28, 2010
Messages
61
phew.. thought I was missing something, lol. Thanks.
 

Perissos

Registered User.
Local time
Today, 07:04
Joined
Jun 28, 2010
Messages
61
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?
 

boblarson

Smeghead
Local time
Today, 04:04
Joined
Jan 12, 2001
Messages
32,059
Use the On Format event of the section the text box is in, not the open event.
 

Users who are viewing this thread

Top Bottom