Setting the .Top property for a label object

[s3tucson]

Hi guys, I'm running into an issue setting the .Top property of a label objective (via VBA) in a form. I am using the following example to set the position:



Reports![Report Name]![Label Name].Top = 4680 <-- This number is in twips

I consistently receive the "The setting you entered isn't valid for this property." message in Access 2016. The label object is recognized, as I am able to successfully set the .Visible property.

Any help would be appreciated! Thanks in advance

[June7]

You say "in a form" yet code references a report.

Have set Top property of controls in form and report. What event are you using?

Formatting code for controls in report sections must be in section OnFormat or OnPrint event.

[s3tucson]

You are 100% correct, sorry about that. This is being handled in a report on an OnPrint event; which is being called properly due to the comment about the .Visible property being set.

[June7]

Just tested. Works in OnFormat, not OnPrint.

I've never used OnPrint.

[s3tucson]

It also just worked for me, great suggestion with OnFormat. It appears there is a limitation with OnPrint and object changes. Thanks for help!

[isladogs]

Whilst this works using the OnFormat event, using this means it has to be done each time the report is printed/previewed.
Why not just do it once? Move it to the required position in design view and save the report.
Then the event procedure isn't required.

[s3tucson]

Thanks for additional response. The report is dynamic in nature based on certain criteria within the query.

[s3tucson]

Hi guys, challenge solved. Thanks again for the help!