Recent content by misterr

The Default View of reports is already set to Print Preview by design. Yes, I'm using Excel Automation for some calculation (statistical and so on). About xlValue on a XY (Scatter) chart: The X or category axis (the horizontal axis in all charts except the horizontal bar charts) is referenced...

This database is used for PQR (Process Quality Review). Y(Values) axis on chart can be auto scaled or manual scaled using two text boxes on form, with this code: Private Sub Detaliu_Format(Cancel As Integer, FormatCount As Integer) If Not Forms![Produse]![Text16] = Empty Then...

Yes, I compiled every time after changings in code, no errors.

Today I tested here at work on all versions of Access. Now the things are the opposite of how they were yesterday, before moving the code to the On Format event of the Detail section: - Access 2016/2019/2021 - the code is working - Access 2010/2013 - the code is not working - it says something...

Yes, you're right, code runs ok in Print Preview. My bad, I tested only in Report View. All is ok now. Thank you very much!

Sorry, I tested now as you suggested both on Access 2016 and Access 2021 and it does nothing. No error on report this time, but also no modification on Min & Max.

Thank you for answer and examples! Unfortunately, we are still using Access 2010/2013/2016 on some machines, so we can not switch to modern charts yet. Also, I understand that MDB databases cannot be converted to ACCDB databases because ACCDB format does not support user-level security, which...

I am using a database created ten years ago under Access 2007, with a chart (Old chart - MSGraph.Chart.8, and not the Modern chart) on a report. Minimum and Maximum of values axis is set by VBA, like this: Private Sub Report_Activate() If Not Forms![Produse]![Text16] = Empty Then...