Forum Discussion
Codice vba report con errore runtime 2424
- Aug 04, 2021
One thing at a time if you don't mind...please post your crosstab query question in a new thread
I had a flash of inspiration based on something similar I've done in the past
So I have a solution for your report issue & I hope your boss is happy with the result!
It will work in report view or print preview
The coloured circles are in fact a Webdings character which is a solid black circle by default
I've then applied conditional formatting to these depending on the value of the number field
Chr(110) is in fact the letter 'n' in a standard font as you will see from the enclosed query
The screenshot was done in Access 365 but the same functionality is in A2010 onwards:
Create a button and then go to the Control Formatting section in the Format menu
Select the ellipse shape and make the button width = height to create a circle. Use the Shape Fill to select the colour you want.
Its easy enough to do...but I still think its an overcomplicated approach. However its your choice!
- Massimiliano_foisAug 04, 2021Copper ContributorEcco
- isladogsAug 04, 2021MVPThe control formatting should be enabled when the button created is selected.
As suggested in my original reply, I would just use conditional formatting for the back colour of the text boxes containing the number values- Massimiliano_foisAug 04, 2021Copper ContributorSi infatti ho fatto così..ma in realtà la text box ha forma rettangolare..purtroppo il.mio capo non vuole un rettangolo ma un cerchio ...un pallina:)))
- Massimiliano_foisAug 04, 2021Copper ContributorComunque ho creato il pulsante ma le opzioni della scheda format rimangono indisponibili
- Massimiliano_foisAug 04, 2021Copper ContributorBeh allora dimmi come posso.ottenere lo.stesso obiettivo con un metodo piu semplice ...