Forum Discussion
Codice vba report con errore runtime 2424
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
Did you import the images to be image library?
This seems an unnecessarily complicated approach. Why not just use conditional formatting for the back colour of the text boxes containing the number values?
OR....if you really must use circles...then you could use circular command buttons of different colours. ..though this would only work in report view
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!
- The 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
- Comunque ho creato il pulsante ma le opzioni della scheda format rimangono indisponibili
- Beh allora dimmi come posso.ottenere lo.stesso obiettivo con un metodo piu semplice ...
