Rectangle.HorizontalAnchor Property Issues

[padlocked17]

All,

I have been racking my brain over what I am sure is a stupid mistake. All I want to do is anchor a rectangle on my report to the right instead of the default left. The ultimate goal is a very simple, horizontal "waterfall" chart.

I've tried the following and I get "You've entered an expression that has an invalid reference to the property HorizontalAnchor".

Me.rectNegative.HorizontalAnchor = acHorizontalAnchorRight

I've also tried declaring a rectangle and then assigning it to a rectangle on the report, but I get a "Object Variable or With Block Not Set".

Dim rect As Rectangle
rect = Me.rectNegative

The reference for the property is http://msdn.microsoft.com/en-us/library/bb241881(v=office.12).aspx

Could someone please give me a pointer?

Thanks,

 

[InitiallyMoved]

Object variable, you must use the "Set" keyword.

Dim rect As Rectangle
[B][COLOR=blue]S[/COLOR][COLOR=blue]et[/COLOR][/B] rect = Me.rectNegative

In addition, you sure rectNegative is a rectangle control ?

 

[padlocked17]

I double and tripled checked. Attached is a screenshot of the form. I tried setting the object variable, and it still is telling me there is an invalid reference.

I've got this in the onFormat event of the Detail section of the form if that has anything to do with it.

Any other ideas?

 

[spikepl]

I am not sure what "simple, horizontal "waterfall" chart." is exactly. But someone just recently uploaded this (sorry, cannot remember the specific post) - perhaps you could use it :

 

[padlocked17]

Thanks, I'll take a look at it.