Can you have shapes on reports?

[Perissos]

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

 

[vbaInet]

You can draw a circle or a line. What's the purpose of this by the way?

 

[Perissos]

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]

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

 

[Perissos]

phew.. thought I was missing something, lol. Thanks.

 

[Perissos]

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]

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

 

[Perissos]

Got it. Thank you so very much!