Controls on reports

[JustJim]

Hi,

When does one have the ability to programatically change controls on a report?

This is related to another thread but is annoying me on other reports also.

Early in the Event Chain the controls aren't available and I get "Can't assign a value" or "Expression has no value" errors. This happens with code in the On Open event

Later, I can't change values or controlsources because the report is getting ready to print or preview. This happens with the On Page event (which I expected) but also sometimes on the On Activate event.

Thanks

Jim

[nico5038]

I normally use the OnFormat event when dealing with variable control settings.
Best however not to "play" too much with the controls, but arrange your data (query) in a way that these manipulations aren't necessary.

Nic;o)

[JustJim]

I normally use the OnFormat event when dealing with variable control settings.

Ah yes, OnFormat of the report's sections - didn't think of that one. Thanks.

Best however not to "play" too much with the controls, but arrange your data (query) in a way that these manipulations aren't necessary.

Nic;o)

Chance would be a fine thing! One day when I get an assignment which doesn't involve fixing somebody else's mangled database....... (see related whinges here)

Jim